Bloody Annoying Problem

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

Hi All

I am trying to import a spreadsheet from excel into Access
and keep getting this bloody error. "Field 'F1' doesn't
exist in destination table". Now I am using the
transferspreadsheet method in VBA but as that would not
work I tried using a macro. Using new blank data base and
new spreadsheet just keep getting the same bloody error.
If I add a field called "F1" then it says the same thing
about "F2" etc. etc. The setting are all default
ie. "hasfieldnames" is set to false.

Please Help while I still have some hair.

Ant
 
I think you have a problem with the column names.

If the spreadsheet does not have column names at the
top, turn off the column name option of TransferSpreadsheet.

If you are expecting column names with TransferSpreadsheet,
make sure the spreadsheet has column names where expected.

(david)
 
Back
Top