Excel – get data via SQL with connection string doesn’t work
I want to create an Excel file that can fetch data from SQL. This should be with embedded username & password so I can pass on the file to a colleague who doesn’t have SQL permissions. I have made sure the SQL users for this is readonly, for damage control.