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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from Pivot Table
Praveen
The quickest way is to summarise the P/T to a single cell, say a total by removing all the row and column fields, leaving just a summed 'value' double click it. So long as there is no more than 65536 rows (up to 2003) in the dataset, Excel will dump the full data file into a new sheet, move this to a new workbook and then import this to SQL -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "praveen" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from Pivot Table
Nick,
Thanks for your suggestion. Is their any way to automate this process in ..Net. I am using ASP.Net with C#. Is it possible to make automate the process. Because i am receiving more that 10 files daily with 5 sheets each in the file . It take lot of time to do the process. Help me. Thanks, Praveen. "Nick Hodge" wrote: Praveen The quickest way is to summarise the P/T to a single cell, say a total by removing all the row and column fields, leaving just a summed 'value' double click it. So long as there is no more than 65536 rows (up to 2003) in the dataset, Excel will dump the full data file into a new sheet, move this to a new workbook and then import this to SQL -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "praveen" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from Pivot Table
Praveen
Honestly,you would do better to 'collate' the data from the files into something like SQL and then use that data source to run your controls in ASP.Net. To automate this many files, with multiple sheets in C# would be tough. (certainly tough for me) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "praveen" wrote in message ... Nick, Thanks for your suggestion. Is their any way to automate this process in .Net. I am using ASP.Net with C#. Is it possible to make automate the process. Because i am receiving more that 10 files daily with 5 sheets each in the file . It take lot of time to do the process. Help me. Thanks, Praveen. "Nick Hodge" wrote: Praveen The quickest way is to summarise the P/T to a single cell, say a total by removing all the row and column fields, leaving just a summed 'value' double click it. So long as there is no more than 65536 rows (up to 2003) in the dataset, Excel will dump the full data file into a new sheet, move this to a new workbook and then import this to SQL -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "praveen" wrote in message ... 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. |
Reply |
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) |