Calling Query from Another DB

S

Sash

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

Wolfgang Kais

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.
 

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Record insert/delete anomaly 0
calling function in another DB 5
MS Access Table missing 3
Access Query criteria based on other field of the same query 0
update query vs make query 5
Programmatically Change Double Data Type To Long Integer 8
Access how to open existing database from another database using Access - VBA 0

Top