如何将Excel工作表数据导出到SQL Server 2005
问题描述:
您好,专家,
我有一个EXCEL工作表,其中包含所有数据..我必须使用查询将这些数据直接放入数据库中..您能告诉我将数据放入数据库中的查询吗.....
Hi Experts,
I Have an EXCEL Sheet which has all the data ..and that data i have to put in the database directly using the query..can u people tell me the query for putting the data in the database........
答
检查这些链接
http ://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/ [ ^ ]
将数据从Excel或使用TSQL脚本从Access导入到SQL Server [ http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx [ ^ ]
check these links
http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/[^]
Import Data to SQL Server from Excel or Access using TSQL Script[^]
using c#
check this
http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx[^]
引用此链接:
http://csharpdotnetfreak.blogspot.com/2009/04/export-excel- data-sqlbulkcopy-aspnet.html [ ^ ]
Refer this link:
http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html[^]
检查以下链接
http://dotnetguts.blogspot.com/2010/01/import-excel-2007-into-sql-server-2005.html [
check below link
http://dotnetguts.blogspot.com/2010/01/import-excel-2007-into-sql-server-2005.html[^]