Changing database used with ODBC link

[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

 

[Andy B]

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.

 

[jspooner]

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?