ImportFromExcelToAccess\Number

[gh]

I am using Excel 2003 and Access 2003. I have a spreadsheet with cells
that have currency values in them. I reformatted the cells as general.
When I try to import them into Access using the wizard I get an error
message. The message is An error occurred trying to import the file.
The file was not imported. I also tried reformatting the columns as
text and number(2 decimal places) an still get the same error. How can
I get the spreadsheet data imported?

TIA

 

[Guest]

Are you sure there is data in all cells? Importing Null values can be a
problem. The best way to avoid data type problems when importing is to
import to an existing table rather than creating a new table. Set up the
table fields the way you want them, then when you do the import, delete any
old data in the table, do the import into the "transfer table", and then do
an append query to move the data from the transfer table to the table your
application uses.