Change contents of AcrtiveSheet.Querytables(1).Connection

HTH
--
AP

"Paul" a écrit dans le message de
...
I am using Office 2000. I have a test and live MySQL database on two
different servers. I have an odbc System DSN pointing to each DB. I have
created a nice report using Excel and the test DB. I cannot find where to
change the DSN for the queries in order to access the live data.

Where in excel is the DSN stored, and/or how can I change the DSN?

I searched the forums, and found how to do it with access, but they were
pointing to files, not ODBC type connections. The SQL editor has the
database
name stored in the from clause, but I need to change the DSN, since the
database name stays the same, just the server changes.