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

J

Jose

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

Thanks for help!
 
K

Klatuu

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