如何将多个Excel工作表行插入到SQL Server 2008的现有表中
问题描述：
大家好，
如何在按钮单击事件中将多个Excel工作表行插入到SQL Server 2008的现有表中.
将通过OpenFileDialog控件选择excel文件，之后我必须将该数据行导出到数据库的现有表中.
我正在使用sql server 2008，MSoffice 2010和Visual Studio 2008
预先感谢您的帮助...
Hi all,
How to insert multiple excel sheet rows into existing table of sql server 2008 on button click event.
will select excel file by OpenFileDialog control,after that i have to export that rows of data to existing table of my database.
I am using sql server 2008, MSoffice 2010 and Visual Studio 2008
Advance thanks for ur help...
答
您好，
请点击以下链接..
http: //forums.asp.net/t/1336761.aspx/1?Import+Excel+File+into+SQL+server+2005+in+ASP+NET+using+c+ [
Hello,
Follow the below link..
http://forums.asp.net/t/1336761.aspx/1?Import+Excel+File+into+SQL+server+2005+in+ASP+NET+using+c+[^]
thanks
sanjeev