Change source database location?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Similar Threads

Cannot get previous data after ctrl + w 0
Changing Data Source 1
Changing Data Links 2
Access to Excel-pivot, changing location of Access 2
excel 2007 right click edit query 1
Access Issue, Macro Single Step, Error 3270 0
if & ands and either indirect or offset - need help fast please 6
Access AutoExec, Runcode Error 2001 1

Back
Top