Relative Content

Tag Archive for sqlexcelconnection-string

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.