External Data (DB2): Using integrated authentication

9

935main

Don't you all love how well excel pulls in data from anywhere? It's
amazing -- I love it. There's just one thing that I need to do that I
haven't found out how to do -- what does it take to have excel send a
blank username and password to the datasource? I'm using Microsoft
Query (the ODBC part of excel) to import data from a DB2 database.
I've got integrated authentication set up with DB2 so you don't need to
send a username and password, but excel doesn't seem to support that.

Any ideas?
 
Top