Connect to a Data Source in Power Pivot

It is important to understand how the Power Pivot Data Model connects to tables in an MS Access database.

Open Database Connectivity (ODBC) is a standard application programming interface for accessing database management systems.
Excel uses Open Database Connectivity (ODBC) to connect to an MS Access database.

Highlights

Explore the commands in the Get External Data group on the Home tab in the Power Pivot window
Understand the steps in the Table Import Wizard to import tables from an MS Access database

Duration: 4mins 48secs

from