How can a multiple-tab excel workbook be converted to access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to use the power of Access to convert an Excel workbook with
12 spreadsheets?

Thanks for help!
 
Sure, that is no problem. One of the arguments of the TransferSpreadsheet
method is the Range argument. You can specify a specific sheet within the
workbook, and even a specific range within the worksheet.
 
You must log in or register to reply here.

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

Voltage supply issue related to NUC PC Core i7 0
Excel shortcut options 0
Import Excel Workbook from Sharepoint 4
Excel Protection 2
How to Convert EML to PST? 2
How to Convert MBOX to PST Online? 3
Import Excel 2010 table into Access 2010 - not listed as range 1
How can we convert OST to PDF file format? 1

Back
Top