I have a Pivot Table Control on a form in Access that is bound to an OLAP cube as the data source. I need to "reverse engineer" the pivot table so that it becomes source data for a table. Is there an easy way to accomplish this? I am open to any ideas at this point.
I had built the pivots in Excel to pull the data and written VBA to "Table Format" the data. The problem is that the refresh time on the pivots in Excel is extremely long. Access refreshes the data much faster. I am not sure why. But a refresh that would take well over an hour in Excel only takes about 5 minutes in Access.