[AccessD] XML Http request from Access 2K2 or 2K3

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



More information about the AccessD mailing list