如何将Excel工作表数据导出到SQL Server 2005 [英] How can i export the excel sheet data into the 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[^]

这篇关于如何将Excel工作表数据导出到SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！