Changing external data source

[Guest]

I am running XL 2000 and use a number of sheets drawing data from a sql
server (running SQL 7.0). This server is being shut down and replaced by a
new one. I have changed the ODBC to point to the new server, but my
spreadsheets still attempt to access the old one. New queries work fine but
these existing ones do not.

I found that by editing my queries, going into the SQL statement in
Microsoft query adding the server name in the form "SERVERNAME:" at the start
they retrieve the correct data. Unfortunately, I then lose the graphical
interface (as per the prompt unable to display graphically).

Is there a way to get these spreadsheets to grab the current server name
from the revised ODBC?

 

[Jamie Collins]

I am running XL 2000 and use a number of sheets drawing data from a sql
server (running SQL 7.0). This server is being shut down and replaced by a
new one. I have changed the ODBC to point to the new server, but my
spreadsheets still attempt to access the old one. New queries work fine but
these existing ones do not.

You may need to change the connection string. See:

http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeConn

Jamie.

--

 

[jb007]

Thanks, that works great