INSERT INTO dbname.dbo.Sperson (PersonNo,PName)
SELECT a.PersonNo,a.PName
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\test\Mytest.mdb ';'admin';'password', APerson)
AS a
SELECT a.PersonNo,a.PName
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\test\Mytest.mdb ';'admin';'password', APerson)
AS a
Sperson﹐PersonNo﹐PName ﹐APerson具体是什幺
------------
表名 字段名,字段名
MSSQLSERVER无法直接生产ACCESS的TABEL,但MSSQLSERVER可以可ACCESS表之间进行更新.
sqlserver只支持导出数据,不支持导出结构
------------------------------------------
导出数据结构不也到出来了吗?USE pubs
GO
SELECT 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