Import Issue

[eao]

Excel 2000, Access 2000

I am trying to import a spreadsheet to a table. The spreadsheet column headings are named the same as the target table. There are no spaces in any of the column names. The target table contains an autonumber field (not sure if this is the cause of the issue or not). The error I receive is "An error occurred trying to import the file '(path)\batch 2.xls'. The file was not imported.

I am able to link to the excel file through the Link Table wizard, but I'd prefer to import the data directly.

 

[eao]

Also, the field that is set to autonumber (BatchID) does not have a corresponding column in the spreadsheet.

 

[Remou]

Can you import the file to a new table?

 

[eao]

Yes.

But I think I found my issue. One of the field names was slightly different than the target. Fixed the name, and the import was successful.