Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from Pivot Table
I am receiving data from client. Its in the form of Pivot Table in excel
sheet. I want to transfer these details to Sql server for further analysis. I cant get the data correctly from the sheet. I tried to get data from Pivot Cache. It show some error message in the Recordset Property on PivotCache as "Exception from HRESULT: 0x800A03EC". Excel version is not as issue. U can provide solution in any excel version. Help me to get data from excel to sql server. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |