SELECT field1[, field2[, ...]] INTO newtable [IN externaldatabase] FROM source SELECT * INTO [Excel 8.0;Database=book1.xls].[Sheet1] FROM Customers SELECT Employees.* INTO Employees IN Backup.mdb FROM Employees;
那就用链接表啦 用Insert into
access提供了in子句用于访问外部数据把c:\db\db.mdb的表1导入到当前数据库:insert into 表1 Select * from 表1 in 'c:\db\db.mdb'
FROM source
SELECT * INTO [Excel 8.0;Database=book1.xls].[Sheet1] FROM Customers
SELECT Employees.* INTO Employees IN Backup.mdb FROM Employees;
用Insert into
Select * from 表1 in 'c:\db\db.mdb'