Change source database location?

[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

 

[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