F1 error trying to import from Excel sheet into Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting Field 'F1' doesn't exist in destination table when I run a macro
to import an excel sheet into an Access table. I deleted all the field names
on the Excel sheet and in the macro for the "Has Field Name option, I
answered No, but I still get the error.

I am pulling my hair :)
 
F1 is the first column in the spreadsheet. if you haven't already, suggest
you post this question to microsoft.public.access.externaldata newsgroup.
your issue is not really with the macro, it's with the import - and the
folks who are best at working with external data, such as MVP John Nurick,
are more likely to answer a post in that newsgroup.

hth
 

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

Importing any excel files with any sheet name into different tables in MSAccess using code 0
importing spread sheets (automate) 7
Importing Excel Spreadsheet into Access 6
Import Table error reports 1
Importing Text Files Into Access 1
How to export table from outlook into ms access table? 0
Office 2007 TransferSpreadsheet Import 5
Importing multiple spread sheets 1

Back
Top