如何在sql sever 2008中配置Openrowset（）？ [英] How to configure Openrowset() in sql sever 2008 ?

问题描述

如何在sql server 2008中配置Openrowset（）？我想插入包含30万条记录的excel表文件。

How to configure Openrowset() in sql server 2008? I want to insert the excel sheet file having 30Thousand records.

推荐答案

浏览这些

http://msdn.microsoft.com/en-us/library/ms190312.aspx [ ^ ]



< a href =http://searchsqlserver.techtarget.com/tip/Using-the-OPENROWSET-function-in-SQL-Server> http://searchsqlserver.techtarget.com/tip/Using-the-OPENROWSET-function -in-SQL-Server [ ^ ]

Go through these
http://msdn.microsoft.com/en-us/library/ms190312.aspx[^]

http://searchsqlserver.techtarget.com/tip/Using-the-OPENROWSET-function-in-SQL-Server[^]

您好，

请参考以下链接：

http://bimoss.wordpress.com/2010/01/07 /如何对使能OPENROWSET-OPENDATASOURCE-在-SQL服务器-2- 008 / [ ^ ]



http://sqlserverlearner.com/2011/enable-openrowset [ ^ ]

Hi,
Refer to these links:
http://bimoss.wordpress.com/2010/01/07/how-to-enable-openrowset-opendatasource-in-sql-server-2008/[^]

http://sqlserverlearner.com/2011/enable-openrowset[^]

参考这些可能对您有所帮助：



http://stackoverflow.com/questions/4777906/sql-server-2008-openrowset-permission-issue [ ^ ]



http ：//www.mssqltips.com/sqlservertip/1643/using-openrowset-to- read-large-files-into-sql-server / [ ^ ]

Refer these may help you:

http://stackoverflow.com/questions/4777906/sql-server-2008-openrowset-permission-issue[^]

http://www.mssqltips.com/sqlservertip/1643/using-openrowset-to-read-large-files-into-sql-server/[^]

这篇关于如何在sql sever 2008中配置Openrowset（）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！