Import fails with the error "Unexpected error from external database driver (1)," Other posted solutions don't seem to apply. Excel file location and import range is correct; file and import table structure and formatting is consistent. Here is the code:
Public Sub ImportSourceData()
Dim sPath As String
sPath = "G:\XE_ECMs\__MOST_REPORT\Reservation Data\"
Src1 = sPath & "MB25.XLSX"
Src2 = sPath & "MB52Inventory.XLSX"
Src3 = sPath & "PKMC.XLSX"
WrhsTrns = sPath & "WrhsTrns.xls"
'Import and delete the data files
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "MB25T", Src1, True, "Sheet1!A1:Q5000"
Note: this import is the first of three into three separate tables. The import data is exported from SAP in .xlsx format.
There is other code below that is not yet edited, but I'm not there yet. The Excel file and database are attached.