SQL Server Login
 

I just upgraded to Office 2003 and I had been using a script in Excell
2000 to import data from a ODBC connection. Everything worked fine in
2000 but in 2003, there seems to be a new option of "use trusted
connection", which seems to be turned on by default. Is there some
option to turn this option off, or can I add something to the trusted
source connection? If not can I add something to my script to recognize
the trusted source? TIA

SQL Server Login
 

It's in the connection string.

The best way I have found to edit is via VBA. Make sure your cursor is
in the Query Table, and then go into the VBA Editor and hit Control-G.
The following will show you what it is, or allow you to reset it:

To fetch the connection:
? selection.querytable.connection

To change the connection:
selection.querytable.connection = "new connection string"

Also, this addin makes working the ODBC Queries via Excel much easier:

http://www.dicks-blog.com/archives/2...editor-add-in/

SQL Server Login
 

Bill, thanks that did the trick...............

Greg