I'm looking for some advice on adding new data to an existing excel spreadsheet.
It's a simple request that we've all had from the boss..."I need a report of X data as is compares to Y data and I want you to put it into this spreadsheet that I've designed."
The aforementioned spreadsheet has a bunch of built-in calculations. All I need to do is access the sheet from SQL Server and add in a few rows of data into specific cells on a monthly basis.
I have basic knowledge of SSRS and SSIS. What I'm looking for is a push in the right direction. I've written a few reports with SSRS. What I would like to know is how to append monthly data to this sheet. Where do I start?
All recommendations on how to approach this report are very welcome. :-)