我想将Excel数据导出到Sql Server 2005 [英] I Want To Export Excel Data To Sql Server 2005

问题描述

你好！
我有兴趣将Excel数据文件导出到Sql Server 2005 SQL
桌子.任何人都可以帮助我实现这一目标.谢谢.

Hello!
I am Interested in Exporting An Excel Data File to Sql Server 2005 SQL
Table. Can Any Body Help me out In Achieving This. Thanks.

推荐答案

使用SQL Server导入和导出向导.

Use the SQL Server Import and Export Wizard.

可以使用以下方法将Excel导出到SQL Server数据库各种方法，例如DTS，批量复制等.

若要使用SqlBulkCopy将Excel电子表格数据导入SQL Server数据库表，请参考以下链接:-
http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx

要使用SQL Server数据转换服务将数据传输到Excel，请参考以下链接:-
http://support.microsoft.com/kb/319951

Export from excel to SQL server database can be done using various methods like DTS, Bulk Copy etc.

To Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy, refer the following link:-
http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx

To Transfer Data to Excel by Using SQL Server Data Transformation Services, refer the following link:-
http://support.microsoft.com/kb/319951

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