Can I "hide" the database login info?

[BrandenK]

I have 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 create a "hidden" or external connection that has the userid
and password already in it so that when the user needs 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

 

[RB Smissaert]

Sure you can.
What database are you connecting to and how?
If it is with ADO then do a Google for: ADO connection string.

RBS