Queries in two different databases

A

Amateur

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
 
S

scubadiver

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.
 
D

Dale Fye

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
 

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

Top