VSB – Importing xlsx excel files into Access

The target db has to have the same corresponding table headers in the excel file. Both header names should be identical. For older version of excels the value should be “acSpreadsheetTypeExcel9”

 

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_myFile", "c:\myFile.xlsx", True

Leave a Reply

Your email address will not be published. Required fields are marked *