Connect Access 2010 to a webserver

[Gijs]

Hi Guys,

I would like to connect my access 2010 db to a webservice wich gives my db some data i need.

Access 2010 supports connecting to webservices: External Data -> More -> Data Services. But then i need to select a 'Data Services Connection Definition File' to establish the connection. This file holds some metadata about the webservice.

Does someone has experience with these kind of files? Does someone has an example for me?

Much Obliged!

 

[zpy2]

a web service return xml, i think you need to use xmlhttp object to obtain this kind of xml.
try search microsoft.xmlhttp.

 

[Gijs]

THX zpy2.

But i have no idea what the structure of the seperate file needs to look like. I'am familiar with use of ms.xmlhttp in regular vba code, but not for a seperate file with metadata...

 

[zpy2]

metodata？i guess you can use split function or dom object to return what you need from xml file.

 

[Rx_]

It has been 12 years ago, I did a large project like that.
There was a 3rd party tool for around a $100.
It included the standard ODBC for Access plus other desktop or larger databases.
The databases included XML sources.
The Link was a drag/drop for connections between tables. Then, a node for each connection allowed for customizing the XML translation if needed.

The output was the xml tranformation layer to use for communication between databaess.
In my case, most certified laboratories automated equipment output data into XML. We had an EPA (Environmental Protection Agency) XML standard for data submission to meet compliance.

This was well over a decade ago. It would just seem that tools like that should exist today. Paying for a useful tool should be cheaper than a person spending many hours trying to accomplish the same goal. In my case, I could have spent months doing what I probably accomplished in two days.