Link a Query

  • Thread starter Thread starter Nightshade
  • Start date Start date
N

Nightshade

Hello,

I want to link a query from a seperate database into my database. I found
how to link a table, but can't find any way to link queries. Can this be
done?

Thank you
 
Hello,

I want to link a query from a seperate database into my database. I found
how to link a table, but can't find any way to link queries. Can this be
done?

Thank you
Click to expand...

Not to my knowledge. You can use File... Get External Data... Import to import
the query, or copy and paste the SQL; it may be necessary to edit the query to
reference linked tables instead of local tables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
lock link tabe 3
Access 2007 - reverse of what Linked Table Manager does 1
Union Query 1
After re-linking tables to a new server, all queries don't see upd 1
Linked Excel File won't update 1
Changing Links to access databases 1
linked tables.....pre designed forms, queries, reports 1

Back
Top