Importing worksheets from Excel
I have an Excel workbook that contains several different worksheets. I want to import all of them into a single database with each worksheet being a different table. How do I do that?
Use Import Records to Import from your Excel file. There's an option that pops up to allow you to select the worksheet from which to import. Do this once for each worksheet and you'll have all your data imported. You can use the new table option to create each table as part of the import if you have not already defined a table for each worksheet.
Note: Only data is imported. Formulas in Excel cells cannot be imported.
Retrieving data ...