These are the two methods I prefer:

(1) Link the tables from one database to another, and do a standard INSERT query, or
(2) Use the IN clause in your SQL Statement, e.g.:

INSERT INTO [MyTable] In "C:\MyData\MyDB.MDB"
SELECT * From MyTable