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.
 
Back
Top