MS Access Database with External Data - cannot import excel datasheet to make access database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

cannot import excel datasheet to make access database

Maria

2005-09-30, 3:24 am

A datasheet from excel cannot import to a access database using the excel
formulas already created. Please let me know howto make it worksame as on
excel?

KARL DEWEY

2005-09-30, 11:24 am

Access is a relational database. It only stores data in the fields of the
records. There is no formating in the storage area - so no formulas, no
colors, no font changes.

The queries, forms, or reports have formating to control the display.
Queries manipulate the data.

"Maria" wrote:

> A datasheet from excel cannot import to a access database using the excel
> formulas already created. Please let me know howto make it worksame as on
> excel?

Sponsored Links