ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I "hide" the database login info? (https://www.excelbanter.com/excel-programming/398118-can-i-hide-database-login-info.html)

BrandenK

Can I "hide" the database login info?
 
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



All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com