alacrity59
Member
Recently we upgraded our servers and moved from Excel 2013 to Excel 365. I am enjoying power query but am frustrated in that I can't find a way to have an excel workbook save the Username and Password required to connect to the SQL database. Also after I manually input the credentials I get nagged that excel cannot connect with an encrypted connection . . . . then I have to accept that I will connect with an unencrypted connection.
The Username and Password credentials have been setup to restrict data access on the server side. This is while I feel safe in storing the credentials with the spreadsheet.
Are there any suggestions as to how I can avoid having to log into each database I connect to manually?
The Username and Password credentials have been setup to restrict data access on the server side. This is while I feel safe in storing the credentials with the spreadsheet.
Are there any suggestions as to how I can avoid having to log into each database I connect to manually?