I'm getting this error:
"Field 'F1' doesn't exist in destination table 'tblImport'"
I am using this command:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImport", filename
filename is a variable containing the full path and filename of the file to be imported. This module imports all files in a certain directory.
If I use this command:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImport", filename, True
It will work, but I have to of course put the field names in the first row in excel. I want to just have raw data, no field names. Am I doing something wrong?