能连上远程的SQL就能写进去。 建议用SQL的连接。 然后在SQL中采用其自带的函数OPENROWSET或OPENQUERY实现。USE pubsGOSELECT c.*, o.*FROM Northwind.dbo.Customers AS c INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders) AS o ON c.CustomerID = o.CustomerID GO
建议用SQL的连接。
然后在SQL中采用其自带的函数OPENROWSET或OPENQUERY实现。USE pubsGOSELECT c.*, o.*FROM Northwind.dbo.Customers AS c INNER JOIN
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)
AS o
ON c.CustomerID = o.CustomerID GO