Export Excel Pivot Table Data into Database

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

0	then use this http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html http://www.c-sharpcorner.com/UploadFile/mgold/Query2Excel12032005011029AM/Query2Excel.aspx Thank you for posting at Dotnetfunda [Administrator] Sudhak, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

Latest Posts