Import multiple Excel sheets

[Nick Giordano]

Hi,

How can I import multiple Excel sheets into MS Access table(s). Note: each
Excel workbook will have sheets of different names. For example, Excel
Workbook #1 - sheets A, B, C, D, E, etc. and Excel Workbook #2 - sheets F,
A, P, D, etc.
I can use the TransferSpreadsheet Method in a loop but need to get list of
Excel sheets dynamically for each Excel Workbook.

Please HELP!!!

Thank you,

Nick

 

[Guest]

Hi Nick - will you be doing this just once or routinly and if routinly will
the names/sheets change?

 

[Nick Giordano]

Hi,
How can I retrieve the sheet names of an Excel Workbook and place them into
a table?
Nick

 

[Guest]

You will have to get familiar with Automation and using the Excel Object
model. The sheet's name is he Name property of the worksheet object.