MS Query
 

We have an Excel spread sheet that uses MS query to access data from a SQL
Server 2000 database. However, the database has been moved to a new server
and although we have updaed the file DSN, the spread sheet is still trying to
connect to the old server.

MS Query
 

Look for this thread in this group, around May 31...

Excel - MS Query - changing location of Access data source



Regards,



Bill

"Louise" wrote in message
...
We have an Excel spread sheet that uses MS query to access data from a SQL
Server 2000 database. However, the database has been moved to a new server
and although we have updaed the file DSN, the spread sheet is still trying
to
connect to the old server.

MS Query
 

how many msqueries do you have in that workbook?
if there's many then vba will solve that if there's only 1-2/3 then you can
use the manual method which can be found in help.


"Louise" wrote in message
...
We have an Excel spread sheet that uses MS query to access data from a SQL
Server 2000 database. However, the database has been moved to a new server
and although we have updaed the file DSN, the spread sheet is still trying
to
connect to the old server.