I have the following requirements

• I have relational content stored in a SQL Server 2005 database.
• I want to retrieve this data, transform it and display it in an Excel 2007 document.
• I would like this to be pulled from within Excel at the click of a button.

As far as I can tell I have the following options...

• Create a view in Sql Server and reference it within a pivot table using a data connection.
• Create an Excel workbook using VSTO and create a web service which the workbook pulls data from
• Create a web service and use JScript with XMLHTTP request objects

I currently only have a little experience of any of these methods (I'm very familiar with SQL Server although not pivot tables, I've created many web services although I've never used VSTO and I've used javascript extensively, but never in the context of Excel manipulation).

Would you recommend one of the above approaches or is there a better way to do this?