Extracting data from Excel Pivot Table

[baltman]

I have an Excel workbook with a pivot table created with an external data source (MDB) that is not available. The data was saved with the sheet. I need to query the data out or export it to a csv. There are several hundred thousand records so the double click doesn't help me.

Any suggestions?

Thanks,
Brian

 

[baltman]

The best solution I could find was to save the workbook as a XML file and then do a low level file read, parse and write into a new file.

Not friendly.

Brian