PowerPivot Connections

[DannyV]

Hello,

I have an Access database which contains numerous tables with differing types of information. I use this information to generate pivot tables within Excel using PowerPivot.

I'm quite new to Pivot Tables and PowerPivot so without knowing what I was doing, I created a different connections to the database for each table I am using to generate my reports. Does this matter? Should I clean this up and have only one connection since all the information is located within one Access database? If it is better to have only one connection, how would I go about doing that? I've searched the internet and didn't find a solution - it could just be that I'm not asking the correct question, but I'm not sure what question to ask...

Thanks for any help.

 

[Chihiro]

It shouldn't matter. You still have to query the data one way or another.

Though you can bring in info (schema) for entire database.

1. Connect to Access, but do not select any table.
2. Click on "Edit"
You will see list of all available tables and views.

Northwind as an example...


Then you can create reference to this connection to expand each table.

 

[DannyV]

It shouldn't matter. You still have to query the data one way or another.

Though you can bring in info (schema) for entire database.

1. Connect to Access, but do not select any table.
2. Click on "Edit"
You will see list of all available tables and views.

Northwind as an example...
View attachment 44887

Then you can create reference to this connection to expand each table.
View attachment 44888

Perfect. I wasn't sure if it would slow down my file, so if it doesn't matter one way or another I'll just leave it this way.

Thanks for your help.