Importing .csv file

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
 
J

Joe Fallon

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!
 

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

Problem with access acImportDelim importing csv with headers 1
Importing txt file 7
Add .csv File Name When Importing Multiple Files Into a Table 0
CSV Import with duplicate field names 3
Import Excel CSV file into Access 2007 2
Import CSV Type Conversion Failure 3
CSV import error only with code 1
import csv conversion & import spec error 1

Top