Access 2010 connecting to web service

[spikepl]

We have a website from which we regularly transfer data input by users. The transfer currently takes place using files. Access 2010 apparently offers possibility to connect to a web service. Unfortunately I have not been able to find any documentation on this feature.

An oft-referred to article is http://office.microsoft.com/en-001/access-help/create-a-web-service-data-connection-HA010356867.aspx but it does not reflect reality at all, for those of us who do not have a Web Service in the Import group (but a "Data Services" thing), and skips over salient details of the most vital point: how to actually connect.

There was a web-service kit one could use for Access 2003 - surely that is no longer required?

Update: I am looking for a tested recipe, where all the ingredients are provided explicitly. Many of the seemingly relevant articles on the web are full of assumptions so one is left guessing, and without any working code.

Does anybody have a link or an example for how to connect to some free web service ( so we could test the mechanism) from Access 2010 (without any Sharepoint involvement)?

 

[spikepl]

As far as I have been able to determine, MS has instituted a world wide action aimed at wasting time of countless developers, by NOT providing all the information concerning consumption of SOAP web services using Access 2010.

Any idiot might think that the 2003 SOAP tool kit that made it relatively easy to get going has been assimilated into A 2010. Any idiot would be wrong, because in A2010 there is no support for digesting WSDL files at all.

Best regards

Any idiot (and angry as hell, too - a few words in the docs would have saved me - and countless others - half a day of fruitless googling).

 

[jdraw]

Spike,

I've looked for examples of vba and xml over the last while and have found little. I'm not really familiar with web services (will read up).
Here's a link I just found - although it seems overview at best - from Albert Kallal that may be useful.
I could not find a Soap/webservices kit for 2010.

http://www.utteraccess.com/forum/lofiversion/index.php/t1979754.html

I did get a few things working regarding exchange rates -not sure how applicable this is - but you can see some at
www.access-programmers.co.uk/forums/showthread.php?t=235233

If you find anything more specific on web services or xml , soap with examples , I sure would like to see them.

Good luck in your search.

 

[jdraw]

Spike,

Found some info here but it is from an Excel blog.

 

[spikepl]

Thanks jdraw great link, for processing XML "by hand", so to speak.

I am still mad at MS for talking about linking to a table using web services (which I'd be happy to do instead of mucking about in some XML details), but failing to mention the boundaries/limitations that apparently preclude using a normal web service.

 

[jdraw]

spike,

Here are more links --the only things I've found with vba.

http://msdn.microsoft.com/en-us/library/office/aa163921(v=office.10).aspx

http://dailydoseofexcel.com/archives/2009/06/16/reading-xml-files-in-vba/

http://social.msdn.microsoft.com/Fo...with-vba-without-using-vsto-2008?forum=isvvba

There is a youtube video (I haven't watched it yet) by Albert Kallal mentioned in this link UPDATE: This is sharepoint related
http://social.msdn.microsoft.com/Fo...ompilation-of-native-vba-code?forum=accessdev


If you make sense of them and wish to explain, I'm all ears.

Access 2010 webservices vba

Later update; http://www.utteraccess.com/wiki/index.php/HttpRequest_Class
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=3259&lngWId=10
http://www.utteraccess.com/wiki/index.php/Access_and_the_web_HTML_Object_Library
http://www.tek-tips.com/viewthread.cfm?qid=1334547