I use TransferSpreadsheet in VBA to import an Excel sheet into a table in MS Access. Right now, I would like to skip a number of columns in the import. When you use the import wizard in Access, you can choose to skip any number of columns anywhere in the spreadsheet. How can I get the same effect in the VBA statement? For example, if I have a spreadsheet that contains columns A - G and I want only columns B, C, and G, how would I get that done?
I know I am able to skip column A by giving a Range of "B:G" but I can't give up multiple ranges... But it should be possible, unless the wizard does additional work (which it doesn't seem to do anywhere else)... I hope.