Importing multiple data ranges from excel

[Taz66]

I'm trying to find an easy way to automatically import multiple data ranges into my database without copy and paste into a new excel tab with the data I need. I'm currently using DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Table_Name", filename, True, "Tab!A1:C20" which is fine to import a full range. What I need is data from say, Tab!A1:A20, Tab!C1:C20, Tab!F1:F:20. Is this possible?

TIA

 

[SQLBI]

Taz,

I'm not 100% certain, but i think you would have to define the individual range names first and then run the TransferSpreadsheet method for each one.

If your smaller ranges are the same each time, you could program Excel to set them prior to the import.

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk