I have a table (tbl_RBaze_imp)with column names. I am trying to import a excel spreadsheet ( ) using the below script. However, I get the error message;
Runtime-Error ‘2391’: Field 'F1' doesn't exist in destination table 'tbl_RBaze_imp.'
One thing I noticed is that I do not see the "Advance" option when attempting to setup a import specification. I am using Access2002. Is there a preference, property or something that will enable this option. Or maybe it has nothing to do with the error message.
xpath = "C:\Documents and Settings\Bazen.xls"
DoCmd.TransferSpreadsheet acImport, , "tbl_RBaze_imp", xpath, False, bazeexport