Field doesn't exist in destination table

K

Kay

I am importing an .xlsx file into an existing Access 2007 table. Received
error message Field 'A851' doesn't exist in destination table ....
Typically this is easy to resolve. However, there is no field A851 in the
spreadsheet. I even tried importing the spreadsheet into a new table, then
re-importing to that table but I received the same error message including
the field name. I have tried scrubbing the .xlsx file and can't find
anything wrong with it. I even recreated the file and saved again to no
avail.
 

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

Access Importing 2
Importing Excel Spreadsheet into Access 6
Exporting/Importing between databases 2
Choosing where the imported fields go in existing tbl 1
Problems Importing Excel Files to an Existing Table 1
Change Field Data Type? 1
Run Time Error '2391.' Field "F1" not in destination table? 2
CSV import error only with code 1

Top