I tried to use "A:P,T:U,W:X" as my range in DoCmd.TransferSpreadsheet acImport but I got the error:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ntblNewItems", GetInputDirectory("New Business") & lstFileList, True, "A:P,T:U,W:X"
Runtime error 3011
The Microsoft Jet Database engine could not find the object 'A:P,T:U,W:X'
Is there a way to just import certain columns from a spreadsheet?