• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PowerPivot Connections

DannyV

New Member
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.
 
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...
upload_2017-8-24_10-51-19.png

Then you can create reference to this connection to expand each table.
upload_2017-8-24_10-54-41.png
 
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.
 
Back
Top