cannot import excel datasheet to make access database

M

Maria

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?
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Subdatasheets within Main datasheets 0
Autonumber field in Excel that behaves the same as Access 0
Need Help with Macro Security 1
Cannot access to Office Insider 0
Importing and Excel Sheet to MS Access 3
Error importing from Excel 1
Excel Accessibility 0
Importing fields from separate excel sheets to fill in info in dba 3

Top