export data from excel to sql using vb.net windows application

Posted by Kannan1986 under VB.NET on 4/6/2010 | Views : 10036 | Status : [Member] | Replies : 6

Hi all,
how do export data from excel to sql 2000 using vb.net windows application

thanks & Regards,

kannan.s

Reply | Reply with Attachment

Posted by: Sagarp on: 4/7/2010 [Member] Bronze

0	Hi friend check following Article http://nishantpant.wordpress.com/2006/11/02/exporting-data-to-excel-from-a-windows-forms-net-application/ Thanks SagarP http://www.emanonsolutions.net http://emanonsolutions.blogspot.com/ Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kannan1986 on: 4/7/2010 [Member] Starter

0	thanks for your reply Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vforvijay on: 2/22/2011 [Member] Starter | Points: 25

0	For this question you can use the link it contains code for both .xls and .xlsxhttp://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Karthikanbarasan on: 2/22/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

0	Hi, Check this thread http://www.dotnetfunda.com/forums/thread2605-how-to-read-xls-file-format-in-windows-application-and-xls-file-datas.aspx Thanks Karthik www.f5Debug.net Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Madhu.b.rokkam on: 2/22/2011 [Member] [MVP] Bronze | Points: 25

0	you can also check this link http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html Thanks and Regards Madhu Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 2/23/2011 [Member] [MVP] Bronze | Points: 25

0	SQl COPY operation?? Kannan1986, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts