External Data: Show Worksheets

A spreadsheet may have many Worksheets or Named Ranges. The Wizard will ask you to select which Worksheet you wish to import.

 

4. Try it: Show the Worksheet

The database is still open.

The Import Wizard is on step 2.

 

There is one Worksheet and it is selected. The sample data is displayed below in the preview.

 

Click Next. Keep going...

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.5. Import data from a single data file: Import into a New Table

External Data ->Import & Link->Excel