How do I use a connection string?
 

I have got my Excel spreadsheet importing the data I need from my database,
but it requires non-Windows authentication. I would like to know if there's
a way to creeate a "hidden" or external connection string that has the userid
and password already in it so that when the user needs to authenticate to
refresh, etc. it will pull the login info from it, instead of asking the user
for it.

Can someone tell me if this is possible, and if so, how? Thanks