I get a runtime error 3265 - Item cannot be found in the collection corresponding to the requested name or ordinal of the following statement:
Docmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TRD", rst.fields("Directory_path"), True, "F:F,K:K,O:O"
where my intentions are to import only those 3 columns.