select into

IN 子句可用于向另一个数据库中拷贝表：

SELECT *

INTO Persons IN 'Backup.mdb'

FROM Persons