- 
In Excel 2007 and 2010, it supports importing data from various data sources, e.g. SQL Server, Analysis Services, etc. But it does not support importing data from “Web Services”. Importing data from Web Services functionality is great to have, so it will save user time to write VSTO code or VBA code to call web services.
Figure: Adding Import from Web Services functionality