David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small. I specialise in Windows Intune and SBS 2008.
This blog is purely the personal opinions of David Overton. If you can't find the information you were looking for e-mail me at admin@davidoverton.com.

To find out more about my Windows Intune BOOK - Microsoft Windows Intune 2.0: Quickstart Administration click here

To find out more about my SBS 2008 BOOK - Small Business Server 2008, Installation, Migration and Configuration click here

How to connect to and import data from an XML Web Service into Excel 2007
David Overton's Blog

Buy my books

Windows Intune:Quickstart Administration


This is the RAW book (Read as Written).
Click here for more information
Buy or pre-order today

SBS 2008 - Installation, Migration and Configuration

Small Business Server 2008 – Installation, Migration, and Configuration

Buy today in book or e-book form

Request a Review Copy

Twitter

Syndication

I have been wondering how to do this recently for one of my own projects and then the subject came up internally.  A very unassuming Hovsep then wrote up the answer, so as a tip here it is - if you follow the link at the bottom you will see a step by step process with screen shots to help you along the way. 

Excel 2007 - How to connect to and import data from an XML Web Service

Many organizations have adopted a Service-Oriented Architecture (SOA) as the architecture of choice. SOA allows a company to expose its services and data in a manner that is compliant with industry standards. SOA is the buzzword these days. Down the wire of SOA is XML data that is exchanged between entities.

Microsoft Office Excel 2007 has built-in features that allow a user to connect to and consume XML data. Such data can be stored in an XML file on the local hard drive, shared in a portal or returned from an XML Web Service.

If you’d like to use Excel to import XML data from a Web Service, follow these step-by-step guidelines. For the sake of simplicity, this document will be using a web service that is available on the Internet called Teach a Techie (http://teachatechie.com). This web service has a function named GetLocation and the URL we’ll be using is http://teachatechie.com/GJTTWebServices/ZipCode.asmx/GetLocation?ZipCode=11413

Go to Hovsep uses SQL Server for Development : Excel 2007 - How to connect to and import data from an XML Web Service for all the details

 

ttfn & thanks to Hovsep.

David

Technorati Tags: ,

Posted Fri, Jul 13 2007 2:05 AM by David Overton

Comments

Paul wrote re: How to connect to and import data from an XML Web Service into Excel 2007
on Mon, Jan 25 2010 8:37 AM

Links from this post are not valid.

Sandip wrote re: How to connect to and import data from an XML Web Service into Excel 2007
on Fri, Mar 12 2010 1:19 PM
Kristian wrote re: How to connect to and import data from an XML Web Service into Excel 2007
on Wed, Oct 5 2011 1:45 PM

GeoNames have some nice demo XML calls that can be tested in place of the above.

Add a Comment

(optional)  
(optional)
(required)  
Remember Me?

(c)David Overton 2006-13