Changing database used with ODBC link

  • Thread starter Thread starter jspooner
  • Start date Start date
J

jspooner

I have a excel spreadsheet containing many (we're talking thousand
here!) of cells which look-up information via an ODBC link to our SQ
Server database. This database has recently changed, so I need to mak
every one of these queries point to a new database in the system
Unfortunately the name of the database appears to be hardcoded in t
each query. I have tried in vain to do a search and replace in a tex
editor on the spreadsheet, but as I feared once I have done this th
spreadsheet no longer opens.

Is there any way to globally update the queries used? I don't fanc
manually updating each and every one of them
 
sooner

You may be able to shortcut this by looking at your ODBC settings on your
PC. If you have a look in your ODBC Data Sources, there may be a way of
changing your PC's perception of which database to use.

Andy.
 
Thanks for the tip. However, I've taken a look around and there doesn't
seem to be anythign which does what you suggest. Anyone have any other
ideas?
 
Back
Top