General discussion
October 25, 2005 at 09:23 AM
saeed_chaudhry

Access Database to Excel Pivot Table

by saeed_chaudhry . Updated 20 years, 10 months ago

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.

Thanks

This discussion is locked

All Comments