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?

If excel will allow you to define a disjointed range then you can assign it a range name and import the name. If excel won't allow it, neither will Access unless you import the data with code that uses OLE automation.

I want rows A, C:E

Click to expand...

I'm assuming that you mean columns A, D:E. You can link the spreadsheet instead of importing it and use an append query to select the columns you want from the linked spreadsheet and append the rows to your table.

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.