I have the need to import 30 files at a time, but I do not need columns A:Z so to speak. I understand range importing, but I'm not sure how to tweak this to skip unwanted columns.
What I have now is something like:
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "destinationtable", varFile, True, "Log!B6:Q100"
And what I'd like to do is something like this:
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "destinationtable", varFile, True, "Log!B6:D100,F6:H100,O6:Q100"
I've been tinkering with it but can't get it to work. Is this even possible?