Calling Query from Another DB

  • Thread starter Thread starter Sash
  • Start date Start date
S

Sash

Is it possible to call a query from another DB and have that query create a
table in my current database?
 
Hello Sash.

Sash said:
Is it possible to call a query from another DB and have that query
create a table in my current database?
Click to expand...

Yes. A make table query can create a table in a different database.
Create a make table query manually and check the sql for details.
Alternatively create a make table query that creates a table in the
local database and add tables from the other database. In the query
designer, use the properties window to change the source property
of a table icon of an individual table or change the source database
property of the query.
 
Back
Top