I've set up a QueryTable using "import external data". Works fine, except I
want to change my datasource. When you import, it pulls in your machine
name, hard coded database name, etc. I don't want that stuff. I want this
much

"ODBC;DSN=MyDB;Trusted_Connection=Yes"

Is there a way to change this from the UI? If not, a way to do it
programmatically?

Thanks