Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting data from Excel Pivot Table

Status
Not open for further replies.

baltman

Technical User
Mar 5, 2002
1,578
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top