How can I specify what columns to import from Excel to Access?

[src23]

Hi !

I'm trying to import an excel spreadsheet into an access table, but I want to import only columns B, C, E to H , M, O and R.

I tried to import all the sheet at once into a temporary table, then run a sql and select into my table only the columns that i'm interested - it's working OK.

But I know there must be a way to specify the range to import (which columns) - but I just can't figure it out what syntax I should use.

I'm talking about the Range argument of the DoCmd.TransferSpreadsheet, i don't know how to specify only those columns to be imported.

If you could show me the syntax, or show me a link where I could find more information about the syntax, you will help me a lot.


Thanx in advance.

 

[marina9]

I don't believe the TransferSpreadsheet Range argument will allow you to slice up a range. It's best to do the temp table as you are doing.

 

[JonFer]

Have you tried naming those non-contiguous columns in Excel and then importing your named Range? Probably won't work but may be worth a try.

John

http://www.interautomateconsulting.com