How to import a query data to a table

  • Thread starter Thread starter joyo
  • Start date Start date
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
 
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.
 
Back
Top