Then the other reply is correct. I never did like using the klutzy MSQuery


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Paul" wrote:
| Dave:
|
| Thanks for the reply. I should have been more specific.
|
| I am not using Macro's or VBA, I am using "Get External Data." When you
| define the query initially, it allows you to select your data source, but
I
| see no way to change it after the fact.
|
| I tried to just change the "Host" parameter in the DSN, from the test to
| live server, but evidentily Excel stores the entire DSN internally, and it
| accesses the test DB anyway.