Push or Pull to Excel for reporting data
- by Nathan Fisher
I am unsure which is the best way to go here.
I have a third party Excel 2003 spreadsheet that needs to be filled in on a monthly basis and emailed.
Currently it is a manual process and I am in the process of automating the generation of the spreadsheet.
I have been throwing around different ideas of how to get the data into the spreadsheet.
I have thought of using SSRS to
create a report that is in a similar
format and get the user to cut and
past.
Alternatively writing a VBA addin
that retrieves that data from a
webservice and then adds the data to
the spreadsheet.
Or using the third party spreadsheet as a template and open it on the server via oledb and adding the data then serving it as a downloadable file.
Which is better or are the better solutions out there?
