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

Posted by Kannan1986 under VB.NET on 4/6/2010 | Views : 8305 | Status : [Member] | Replies : 6
Hi all,
how do export data from excel to sql 2000 using vb.net windows application


thanks & Regards,


kannan.s




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
SQl COPY operation??

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

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

Login to post response