把數量放在MSSQL再放到Access不行麼?參照語法和例子 http://msdn.microsoft.com/zh-cn/library/ms190312%28v=SQL.90%29.aspx USE Northwind GO SELECT c.*, o.* FROM Northwind.dbo.Customers AS c INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb';'admin';'', Orders) AS o ON c.CustomerID = o.CustomerID GO
http://technet.microsoft.com/zh-cn/library/ms179250(SQL.90).aspx
把數量放在MSSQL再放到Access不行麼?參照語法和例子
http://msdn.microsoft.com/zh-cn/library/ms190312%28v=SQL.90%29.aspx
USE Northwind
GO
SELECT c.*, o.*
FROM Northwind.dbo.Customers AS c
INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb';'admin';'', Orders)
AS o
ON c.CustomerID = o.CustomerID
GO