Access and web services

[TexasAggie96]

Let me first state that I have used web services before, but only
through MS VS.NET and with using a WSDL for interface self
documentation.

I need to use web services to retrieve data from a new server
application and pull this data into MS Access. The web services
associated with the application do not use a WSDL and from my
understanding, the way you talk to it is by creating a XML soap message
with needed parameters and post that message to the web service and
then pick up the response.

My question is, how can this be done short of VBA? Are there any
software add on's available for Access 2003 to help in this process.
Are there any good links on the web that describe how to do this? Any
help with this venture would be greatly appreciated.

James Wallace

 

[Rick Brandt]

Let me first state that I have used web services before, but only
through MS VS.NET and with using a WSDL for interface self
documentation.

I need to use web services to retrieve data from a new server
application and pull this data into MS Access. The web services
associated with the application do not use a WSDL and from my
understanding, the way you talk to it is by creating a XML soap
message with needed parameters and post that message to the web
service and then pick up the response.

My question is, how can this be done short of VBA? Are there any
software add on's available for Access 2003 to help in this process.
Are there any good links on the web that describe how to do this? Any
help with this venture would be greatly appreciated.

James Wallace

Without using VBA? No.

 

[Albert D. Kallal]

You have to use VBA, but yes..there is a web (soap) tool kit add in for
a2003.


http://www.microsoft.com/office/previous/xp/webservices/toolkit.asp

Take a look at the above screen shots, they are quite cool. You can see that
it is quite easy to use .net services in ms-office now.

http://msdn.microsoft.com/office/downloads/toolsutils/default.aspx