I am importing an excel spreadsheet into an access table. I have coded the import as:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel15, "tbl_TempImport", strInputFileName, True

the variable "strInputFileName" contains the full path name of the excel file. The option 'True' says to use the header row as the access table column names.

I have about 40 spreadsheets that have had data entered. I have been able to load about 1/2 and then the other are giving an error on the import stating "Field 'F2' doesn't exist in the destination table "tbl_TempImport". The spreadsheet do not have 'F2' in the header column, they have the real column names. I'm befuddled on where this 'F2' column name is coming from.

This is the first time I have imported excel data into access tables. I am not saavy with Excel at all. I am sure there is something wrong with some option or something in the spreadsheet that my users changed somehow. Otherwise, half of them would not be working correctly.

Any help would be GREATLY appreciated!!