General discussion


Access Database to Excel Pivot Table

By saeed_chaudhry ·
I need to set up Excel Pivot Tables from a Access database. Problem is that when I did it through a OLAP CUBE I get the general info and it works fine, BUT I need for them to be able to drill down to the data. You know, just like when you run a Excel pivot table from an Excel worksheet and then you can double click the cell to drill to the data...I need that when I make a pivot table from an Access database. PLEASE HELP ASAP.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

access DB P/Tables

by Khalid_Butt In reply to Access Database to Excel ...

Saeed Aslam o la kum

Have you tried just doing the pivot table from within access which version of access do you use?:
in the query desgin mode click view then pivot gtable view you can drill right down

Related Discussions

Related Forums