A user has an excel document and there are 5 specific cells they need to populate. The data is in one of our SQL databases. Is it possible to create a new copy of that excel doc with those fields populated for each record? There are around 2000 records they don't want to manually populate each one.
I have never tried this before so not even sure if this possible or not.
You can complete this task using Powershell - which lets you reference\instantiate the Excel doc - and also specifically focus on certain cells. You can also connect to the SQL Server Instance - execute the query - and place in the cells above. Check the Excel COM object and the New-Object ('Microsoft.SqlServer.Management.Smo.Server') to connect to the SQL Server Instance