How to copy a saved query from PC to another?

  • Thread starter Thread starter Martha V
  • Start date Start date
M

Martha V

I want to copy a query that was created on one pc to
another pc so I can run it off the new one and the old one.
This is an ODBC database query.
Anytime I try and copy or send the query, it either runs
the query or just sends the data.
Any suggestions how I do this?
 
If the two machines are networked together, you can use the TransferDatabase
method to export the query from database 1 into database 2. Failing that,
open the query in SQL view, copy the SQL to a text file, open the second
database, create a new query, switch to SQL view and paste the SQL into the
new query. Yes, this latter approach can be automated if need be.
 
Back
Top