Import Data into Access:

Get External Data

There is an Import Spreadsheet Wizard that walks you through the process of importing data into Access. The steps ask to find the data and identify the Header Row

 

2. Try it: Get External Data

The Front Row Video database is open.
Go to External Data ->Import & Link-> Excel.

 

Try This, Too: Browse for the Data Source

Select: tblMoviesNEW.xlsx

 

Try This, Too: Specify How to Store the Data

The three import options include:

Import into a new table

Append (add) records to a table

Link to an external table

Select: Append and choose a Table: tblMovies.

 

Click OK. Keep going...

Microsoft Access->External Data ->Import & Link-> Excel

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.5. Import data from a single data file: Append Data into an Existing Table