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

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