Every month I have to fill in an Excel template with data from some database, that is I have to fill in about 100 cells.
I wrote SQL queries and I don't know is there any way that I could get that data into the Excel template other than copy/paste?
In the Data tab in the ribbon, click on the From Other Sources tab. Choose Sql Server.
Type the name of the SQL Server computer in the Server name box.
You can also paste in your SQL query via the Properties tab (after a connection is set up, under the connections pane).