External Data: Field Options

The Import Wizard will prompt you to review the Field Options for each Column in the spreadsheet.

 

6. Try it: Review the Field Options

The Import Wizard is on step 4.
The First Column, Movie, is selected.

What Do You See? The Field Options include:

File Name

Indexed: No (Duplicates are allowed)

Data Type: Text
 

Please accept the default answers for File Name, Indexed and Data Type.

 

Click Next. Keep going...

External Data ->Import & Link->Excel

Exam 77-885: Microsoft Access 2010

2. Building Tables

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