Excel to support Import Data from Web Services

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

Figure: Adding Import from Web Services functionality

Related link

Access to support Import Data from Web Services

Sometime, users may want to get data from Web Services provided by other party. It is a bit cumbersome to do at the moment, since Access 2007 and 2010 does not support importing data from Web Services. Users may need to write VSTO code and VBA code to call the web services. It will be very helpful if Access supports importing data from Web Services.

Figure: Adding Import from Web Services functionality

Figure: Adding Import from Web Services functionality