Import all sheets from Excel file

E

Ernie

I could be wrong (and if so, should be lashed with a wet
noodle), but I believe that the "TransferSpreadsheet"
function has an option to transfer multiple sheets from a
single workbook just by naming them.

There's an example somewhere in this forum that shows how
to do it.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Possible to import a specific sheets data from excel into access? 1
Import Excel Workbook from Sharepoint 4
Import Excel 2010 table into Access 2010 - not listed as range 0
Import multiple Excel sheets 3
importing multiple worksheets from excel to access 1
Manipulating Excel from Access 9
Import specific sheet from Excel workbook 6

Top