grpahic2
graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.1 Create a Table: Import External Data into Tables

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

External Data ->Import & Link->Excel