TransferSpreadsheet Range

I have a spreadsheet that I'm importing into a table using TransferSpreadsheet. We are recieving this spreadsheet from a client and do not want all the fields imported into our system and I want to make this as fast and user friendly as possible. I know to set the range argument you use sheet1!A:H. Does anyone know how I can set multiple ranges for example I want rows A, C:E. Can I specify this in the range?

I created a temp table that has all the fields and then an append query to transfer the data from temp to finalTable and then empty the temp table...

Pat,

Excel allows me to select columns that way but when I place it into Access it does not allow me to do it. I can not link the spreadsheet because there will be a different one each week and I wouldn't want to relink them each week. I'm assuming I will have to go with Surjer's idea and import them into a temp table first.

Thanks both of you for your help.