I am trying to import a large spreadsheet into access with the following code:
DoCmd.TransferSpreadsheet acImport, , "import_" & worksheet_list!worksheet, path & "\input_files\" & rnc_list!RNC & ".xls", True, worksheet_list!worksheet & "!A:HA"
But I get this error: search key not found...