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