Get External Data: Import Tables
What Do You See, Now? You can choose:
Table
PivotTable Report
PivotChart
Only Create Connection
This time, we will import the data from Access into Excel as Tables.
The two Tables will be added to a PowerPivot Data Model
when it is imported.
3.
Try it: Import Data
Select Table.
Select New worksheet.
Confirm: Add this data to the Data Model (default).
Click OK.
Keep
going...
Very Important! Look again at the Properties:
If you select multiple Tables Microsoft Excel will Import the relationships between tables.
