How to Import Multiple Access Database Table Directly into Excel Pivot Table

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