graphic2
graphic1

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

pic2

Get External Data

Microsoft Access can import records from almost any data source including big IBM mainframe systems and small QuickBooks financial records. Of course, Microsoft Access can import data from Excel.

 

2. Try it: Get External Data

The sample database is open.
Go to External Data ->Import & Link.

Click on Excel.

 

There is a wizard that walks you through the process.

Keep going...

External Data ->Import & Link->Excel