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
Awesome post! Looking forward to arrange Excel training for my company’s staffs