Good afternoon, I am attempting to import from excel to an existing table in access. I have a long code, but am struggling with one line. I want to import selected columns as my spreadsheets can include >50,000 rows and do not need all the other data from the other rows. I only need columns L,O,P,R.
Currently works importing rows L through R as expected.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImportFM_Sol", SelectedFile, True, "Solicitations Detail!L:R"
I have tried multiple different ways, but cannot figure out how to do selected columns. Only thing I can find with research is below and it gives me the error code 3011. I do not want to try and put it in a qry and do sql.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImportFM_Sol", SelectedFile, True, "Solicitations Detail!L:L,O:O"
Any help would be appreciated.