Reading XML Data from a Web Service

  • Thread starter Thread starter Edward V. Dolikian
  • Start date Start date
E

Edward V. Dolikian

Looking for information on how to link to a web service
and retrieve / use XML data within my Access 2000
database.

For example suppose I have a webservice called GetQuotes
("SYMBOLA","SYMBOLB") which returns an XML stream
containing current pricing, volume, etc... for each
symbol). can I use code to call this service and load
the schema and parse the result into somesort of object?

I assume this is possible since XML is the data exchange
method of choice but I have yet to see any examples /
articles outside of the .net environment.
 
Edward V. Dolikian said:
Looking for information on how to link to a web service
and retrieve / use XML data within my Access 2000
database.

For example suppose I have a webservice called GetQuotes
("SYMBOLA","SYMBOLB") which returns an XML stream
containing current pricing, volume, etc... for each
symbol). can I use code to call this service and load
the schema and parse the result into somesort of object?

I assume this is possible since XML is the data exchange
method of choice but I have yet to see any examples /
articles outside of the .net environment.
Click to expand...

You can use the MSXML.dll library. Any Windows system with Internet Explorer 4
or higher should have it. You can use that to create a XML DOM feeding it the
stream from the URL and the process it from there.

I do this to exchange XML data between a client app and a Java servlet running
on our company's web server.
 
Back
Top