docmd.transferspreadsheet from excel to access with different range

[mlrucci]

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.

[CJ_London]

You cannot select specific columns only a range

Suggest use transferspreadsheet to link to the excel file then have a query using the linked table as a source to append to the destination table

[mlrucci]

Thank you.