Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming |