How to import a query data to a table

[joyo]

How to import the data in a query to a table in another
database. I tried to use 'transferdatabase', but it only
import the query without data.

Thanks

joyo

 

[Wayne Morgan]

One way would be to set up a linked table in the database the query is in
and change the query to an Update Query. Use it to update the linked table.
If you're trying to do this from the receiving database, link the
appropriate tables from the sending database, make the Update Query in the
recieving database and again run the query to do the update.