I am trying to import an xlsx file into access but seem to be having some difficulty.
The code i am using is:
' Import into Access:
DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel97, strcTableName, _
I think the error is with "acSpreadsheetTypeExcel97" but i am not sure.