Export Excel Pivot Table Data into Database

Posted by Sudhak under C# on 2/23/2010 | Views : 7311 | Status : [Member] | Replies : 7
Hi,

My requirement is to export the data of the pivot table in excel worksheet to the sqlserver database.

I have tried it but I am able to get the rowlabels,column labels, report labels but not the data.
Please can anyone has the code / solution.


Regards,
Sudha




Responses

Posted by: Abhi2434 on: 2/23/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
did you try Interop?

Check this :
http://www.eggheadcafe.com/community/aspnet/2/10050513/solved--export-data-from.aspx

This is an option as well :
http://www.codeproject.com/KB/miscctrl/Excel_data_access.aspx




www.abhisheksur.com

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudhak on: 2/23/2010 [Member] Starter

Up
0
Down
Hi,

My problem is:

I have a pivot table in worksheet. I need to populate the data into SQLSERVER.

Regards,
Sudha

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 2/23/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
You want to create the table in the Destination database ?

Thank you for posting at Dotnetfunda
[Administrator]

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudhak on: 2/23/2010 [Member] Starter

Up
0
Down
My database already contains the table structures . I need to populate the data present in pivot table to the destination database tables with c#

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 2/23/2010 [Member] [MVP] [Administrator] NotApplicable
Posted by: Abhi2434 on: 2/23/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
I think for you it is better to use Excel Interop.

Data access tool will not be capable of exporting if the data integration is not perfect.



www.abhisheksur.com

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 2/24/2010 [Member] Bronze

Up
0
Down
Check the links
http://social.msdn.microsoft.com/forums/en-US/vsto/thread/4678964f-839b-4971-8178-2e26ddc77fec/ http://bytes.com/topic/visual-basic-net/answers/470301-excel-pivot-tables-vb-net

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Sudhak, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response