Changing Server on a Microsoft Query

G

Grantley

I have a query in a spreadsheet. It is pointing at a server and SQL
database. How do I change the location of the server?
The query is not saved anywhere, it is only embedded in the sheet. Changing
the ODBC I originally selected in Control Panel makes no difference.
Where is it storing the connection information???

Thanks.
G
 
Top