Importing from excel to access 2003

[jdupaix]

I am importing 1,500 records into my access program from excel and I recieved the following error

An error occurred trying to import file 'C:\...09.xls'. The file was not imported.

Thank you in advance for all of your help!

Joe

 

[gemma-the-husky]

possibly the field headers (row 1 of the spreadsheet) dont match the field names in the access table you are importing to

OR

the table is open in excel while you are trying to import it

 

[jdupaix]

The headers on my excel file match the field names (excel has 10 fields and access and 16 fields) and I have tried to import with excel open and closed.