Insert records from one table to another database table

[Guest_imported]

Hi everyone,

It's finally Friday, and you guys don't have to use the alarm clock..for 2 days..(*_*)

I have 2 databases. One, called mdb1, is in drive C, and the other called mdb2 is in drive D. How do I insert records, resulting from a SELECT statement, from mdb1 to a mdb2 table?

Thank you for any response.

Frank,

 

[Databaseguy]

An easy way would be to use an append query. Link the table from Drive D: to the DB an drive C: using the file/get external data/link tables.....

Otherwise, you're going to have to write a little VBA code to open the other DB, create a recordset and use the INSERT INTO SQL statement.