Robin Lawrence
rgilimited at btconnect.com
Tue Dec 23 02:25:02 CST 2003
Erwin, MSXML has a HTTP 'GET' and 'POST' operation which I think will do what you want.. Don't have any useful code here but there's an SDK and all the info at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/ htm/dom_devguide_overview_2g1j.asp HTH Rgds Robin Lawrence -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: 22 December 2003 16:46 To: Access Developers discussion and problem solving Subject: RE: [AccessD] XML Http request from Access 2K2 or 2K3 Euh, I don't think so... I explain more detailed. My supplier allows me to constuct a url which returns a XML file in a browser. For example http://www.websitedummy.com/xml/xmlonl.asp?custid=MyCustID&prodid=783662 (Real Example but I replaced the website and cust id for obvious reasons) As a (real) result I get an XML file looking like this in my browser. <?xml version="1.0" ?> - <RealData> <MSG ID="0">ok</MSG> - <ITEM> <ID>783662</ID> <DESC>LCD 1501-BK 15" TFT 0.297mm 60kHz 1024 x 768 TCO99 Black</DESC> <PRICE CURRENCY="EUR">266,71</PRICE> <QTY>0</QTY> <DELDATE>07012004</DELDATE> </ITEM> </RealData> I want to know if I can do this straight away from Access 2K2 or 2K3, knowing that Access suports XML. Isn't this what XML is all about? Connecting anything to anything??? Or am I to positive thinking? Well, I could resolve this with my http Active-X control I have, but I always prefere to use native Access functionality above purchased controls. The reason why I wanna do this is to startup my E-commerce website next year. I want to be able to update my article database automaticaly with stock and purchase information, etc... This database is used for my internal application and both E-commerce website. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, December 22, 2003 4:54 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] XML Http request from Access 2K2 or 2K3 You can open a recordset on an xml file, if that's what you're looking for. Charlotte Foust -----Original Message----- From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] Sent: Monday, December 22, 2003 1:47 AM To: Access Developers discussion and problem solving Subject: [AccessD] XML Http request from Access 2K2 or 2K3 I never looked in to the XML support for Access. Apparantly there is XML support, but the only thing I find is a import/export filter. So I'm wundering if I can do a specific http xml request straight from a form, in an easy way? Erwin Craps Zaakvoerder www.ithelps.be/jonathan This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com