Software

Ask something
Discussion Locked

Access Database to Excel Pivot Table

0 helpful
1 reply

by saeed_chaudhry

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by khalid_butt

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

This discussion is closed to new replies.