Export Table Into Another One

[FiDz]

Hello;
How can i cut some data from some tables, and paste it (add it) to another table in another database? is there an easy way to do with VBA? am planning to export some data into another standard database.

Thank you;

[RobDog888]

You can do it by creating an INSERT INTO query. Add a join to the second
database table or query. This way you can select only the records you want.

Or you can simply do a copy from one table and paste into the other table in
the other database.

HTH