检查这些链接

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[^]