In many cases, you will want to import multiple records from an Excel table. Excel Import relies on Linked tables to pick up the data from these tables:
If all's will, the new table will appear in the Source combo box*. Additionally, a listbox appears showing the selected file name, and buttons to Add and Remove file from list, and change the table range.
If you switch to View Input tab, you will see the Excel table data to be imported
* or else you may get the message: Microsoft Office Access does not support linking to an Access database or Microsoft Office Excel workbook saved in a format that is a later version than the current database format (click the link to read more).
Next: Select Destination Table
|Importing Excel files|