Insert data into an existing excel spreadsheet


  • Hello,

    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. :-)

    Friday, October 16, 2009 3:27 AM


  • Hi,

    Due to this is SSRS forum, you should post the details here on what you would like to do on your reports. And then ask the question on how to export data logically in SSIS forum.

    thanks for your understanding.

    Monday, October 19, 2009 8:15 AM