How to import a query data to a table

J

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
 
W

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.
 
Top