OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries解决办法

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries
当要把Access的数据导入到SQL Server中时，出现了如下错误，
我用的是64 bit OS， 64 bit SQL Server.

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.



------解决方案--------------------

如需要阅读该回复，请登录或注册CSDN!

------解决方案--------------------

SQL code

没用过64 bit OS， 64 bit SQL Server,不懂，帮顶，学习，蹭分.
------解决方案--------------------
探讨


select  * into newtab  from Openrowset(''Microsoft.Ace.Oledb.12.0'',''c:\database.mdb'';''admin'';'''',link)

这个sql有问题把，怎么这么多单引号？