Queries in two different databases

[Guest]

Dear Sirs

I would like to use data from a query from Database Nº1 in a query of
database nº 2. To create a query in database Nº 2 I would like to use
"Select" in the field to get the data from DB Nº1.
I did the following:
Under Criteria in the field of the query I wrote:
SELECT salespersonID FROM salespersonal in C:\cps207.mdb
Result: No data is shown in that field of the query.
Any idea what I did wrong and how I can solve my problem?
Thanks
Klaus

 

[Guest]

I had to laugh at that post (sorry!).

Tables contain records. Queries do not contain or store records. They are
used to format and add "on-the-fly" information.

You need to link the table from one database to the other before creating
the query.

 

[Guest]

Answered you yesterday. No, you don't need to link the table, and you cannot
link queries.

You need to do this in the SQL view, not in the query grid. You must also
enclose the name of the mdb you want to pull the data from in quotes.

SELECT SalespersonID from Salesperson in "C:\cps207.mdb"

HTH
Dale