How to find all Excel files that have an SQL Connection string?
I’ve been tasked to do an audit of all the company wide Excel files, that could possibly be using SQL Server connections to source data? This is to determine the scope of work required to convert legacy connection strings (ODBC) over to a stronger and encrypted framework, of which I am still researching to determine what is best practice here.