SQL IN clause - Copy tables into another database

The IN clause can be used to copy tables into another database:

SELECT Persons.* INTO Persons IN 'Backup.mdb' FROM Persons

create database sampleBackup;

SELECT tbl3.* INTO tbl3 IN 'sampleBackup.mdb' FROM tbl3;

DROP DATABASE sampleBackup;

use sample;