Sql server in Excel via web service

Question

I would like to know how best to transfer data from a web service to an excel worksheet (office 2007). I am not interested in reporting to succeed from the website. In our scenario, the user will use excel (with several macros, etc.) and will request about 11,000 rows of data from the server to the worksheet.

Does anyone have any experience?

early.

Answer 1

Check in SharePoint and Excel Services exactly what it is designed to run. You can publish data sources to SharePoint for any users that will be used in Excel, and keep your Excel spreadsheets up to date in the data warehouse.

Architecture Overview:

http://technet.microsoft.com/en-us/magazine/2009.02.bookbi.aspx

SQL Server Log Implementation Guide (subscription required):

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=99355&pg=2

Answer 2

, Excel -, - -. , , ASP.NET, , GridView.

"-" Excel. "" → " " → " -". -, , .

, ( ) ..

- VBA, .

Sheet1.QueryTables(1).Refresh

Answer 3

SQL SSIS webservice http://msdn.microsoft.com/en-us/library/ms140114.aspx

excel.

Answer 4

, - , , Excel VB script, -. .

, , , this Microsoft /, this.