working with 2 Access DB

[Guest]

Dear Sirs
I would like to build a query in my DB using the data from a table of
another Access DB.
Can I do that? And if possible, please give me a ste-to-step explanation how.
Many thanks in advance
Klaus

 

[Larry Linson]

I would like to build a query in my DB using the data from
a table of another Access DB. Can I do that? And if possible,
please give me a ste-to-step explanation how.

In Access 2003 or earlier, on the File menu, Get External Data, choose Link,
and follow the prompts to choose the Database and Table to link. Once it's
linked, you can use it almost as though the linked Table were in your
database, and for the purposes you describe you can use it exatly as though
the linked Table were in your database.

Larry Linson
Microsoft Access MVP

 

[Guest]

The easiest way is to link the table from the 2nd database into the first one.

Open the first database, Select File -> Get External -> Link from the Access
main menu.

When the dialog box opens, navigate to and select the 2nd database. Then
select the table or tables from the second database that you want to link,
and click "OK"

The other way is to write your query in SQL view, it will look something like:

SELECT * FROM tableName in "C:\SomeAccessDatabase.mdb"

HTH
Dale

 

[Guest]

Thanks, table data I got.
How does it work if I want to build a query in one database using the data
from a query in another database?
Thanks for your help.
Klaus