MS Query

[Guest]

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.

 

[Chandra]

does the spreadsheet use the same DSN that u have made changes to??


best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/

 

[William Benson]

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

Excel - MS Query - changing location of Access data source



Regards,



Bill

 

[Guest]

Yes it does

 

[faisal QADEER]

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.