hi Dave,
if i understand you, you want 1 MSQ to select from 3 different db tables. If
the dbs are on your hard drive the table1 in first db will always exist and
be selected first always.
I have worked with MSQs a good deal in the past (not recently) and found
that MSQ is not that sophisticated. My suggestion is to have 1 workbook with
3 sheets and 3 MSQs, one for each of your dbs. you could record a macro to
run each one after the other.
my thoughts.

Regards
FSt1

"savalou" wrote:

Hello,

I'm trying to pull data from access to excel using MS Query. I have
three Access databases (for three different countries) that will
reside in three seperate subdirectories on the harddrive. I want to
create one excel file that will work for all three applications.
Problem is that the data source is hard coded into the MS Query. Is
there some syntax in SQL that I can use to find the correct data
base?

like,

select table1.* from c:\app1\table1.mdb if exists
else select table1.* from c:\app2\table1.mdb if exists
else select table1.* from c:\app3\table1.mdb.

or something like that.

Thanks!

Dave