Import multiple Excel sheets

  • Thread starter Thread starter Nick Giordano
  • Start date Start date
N

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
 
Hi Nick - will you be doing this just once or routinly and if routinly will
the names/sheets change?
 
Hi,
How can I retrieve the sheet names of an Excel Workbook and place them into
a table?
Nick
 
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.
 
Back
Top