不好意思又有新问题了。
我试了下下面的方法
select ID,Title,OwnerName from
opendataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:/BJData.mdb";')...BJAdmin
但是报下面的错误:
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.
select ID,name1 from
opendataSource('Microsoft.ACE.OLEDB.12.0','Data Source="C:/Users/Administrator/Desktop/AccessDB/Database1.mdb";')...table1
就会出现和上面那个一样的错误
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.