Change source database location?

D

DAna

I have an excel document that runs a query to get several sheets of data from
a ms database. I need to change the location of the database but cannot find
where to change the location in the excel query. Please help. Thanks Dana
 
J

John Michl

You'll need to do this in VBA.

Try searching Google groups for
excel programming change database
and you'll probably find the code needed. I did this a while back but don't
have that code handy.

- John
 
Top