I need to import data from an excel file into an access table. I will need to import only certain columns from the excel file, columns A C D and E, but all of the rows that have data from all of the sheets. The needed columns will be the same for each sheet.
I know I can use the DoCmd.TransferSpreadsheet but how do I import each sheet and only the columns that I need? The number of sheets each time could change.
This is for Access 2000 DB.