Welcome to Excel Jet Consult blog post. In this blog post, we want to learn how to succinctly import multiple Access Database table directly into Excel Pivot Table and create a relationship for further analysis. The caption below is one of the Access Database table we want to import
To import the tables:
- Open a new Excel workbook and executive ALT + DDD.
- Browse through the location of the Access Database
- Click Open and check Enable selection of multiple tables
Select the following tables: DimCustomer, DimDate and DimGeography
Click OK.
In the Import Data dialogue box, Pivot Table Report
Click OK.
Task Completed for further analysis in the Pivot Table