Transferspreadsheet to import excel file with different column

[samhck2]

Hi All,

I need to import an excel file with different columns, ie: A3:B, D3:E
and G3,J. I don't need column C and F.
I am using code below but it doesn't work. Can anyone help??

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"CMSTbl", xlPath, True, "A3:B, D3:E, G3:J"

regards,
Sam

 

[George]

Why not try this?

Import the exel into a temp table with all of the columns and write an
append query to move just the columns you need into your permanent table/

 

[samhck2]

George,

But, my data import is a lot and perform daily. If create another temp
table, it will increase the database sizes, which I don't want that.
Any other ideas beside import into temp table?

Thanks for your suggestion. Appreciate it.

 

[John Spencer]

Use a temporary work database and link to the table in that work database.

See Tony Toews website
http://www.granite.ab.ca/access/temptables.htm
for an example

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[samhck2]

Thanks John Spencer, I will give this method a try.

 

[mcnews]

Use a temporary work database and link to the table in that work database..

See Tony Toews website
     http://www.granite.ab.ca/access/temptables.htm
for an example

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

or long-hand the import.