Importing .csv file

  • Thread starter Thread starter Ms. De
  • Start date Start date
M

Ms. De

Error 2391, Field 'F1' doesn't exist in the destination
table


Why do I get this error when I try to append data from
a .csv file into an Access_97 table

code line:
DoCmd.TransferText acImportDelim, , "Invoice", Filename,
False

Please help
 
The Excel spreadsheet may be "broken".
The data needs to be in a rectangular area.
So copy the data and paste special (values) to a brand new worksheet.
Then import that.

This effectively gets rid of any "stray" columns.
You may not think there is data in them but Access does!
 
Back
Top