Run Append Query From Different Database

[jo15765]

I have my test database and my production database. Well once things pass testing phase, I want to be able to just append results from my test database into my production database. So I want to be able to from my Tools.mdb database run an appened query from a table in my test.mdb into my production.mdb. What would be the syntax to do such? I know how to query from one database to another, but a 3rd unrelated db I can't figure out.

[JoeM]

Just link the tables from your Test database into your Production database, and then create your Append Query in your Production database. The syntax is the same. It doesn't matter if the data is inherently found in that database, or from a linked table.