Access 2003 - Send og modtag XML (VBA?)

In Access you can export your data (tables) in XML format.

First design your tables and then make a form using the form wizard.

Now you can enter your data which gets written to your table.

to upload/download your XML files you will need to use FTP there rae NO inbuilt functions for doing this!

do you need help here?

Thanks for answering and sorry for not replying before this.

I have not used enough time looking into your suggestions to see if I can make it work... but I will get back to it.

If I understand you right I need to use forms looking identical with the design of my Import/Export XML files and when sending the xml files back and forth you mention using ftp. I have never played around with ftp in Access but I will look into it.

Thanks once again and sorry for keeping you waiting...

Here is a link on FTP. http://www.mvps.org/access/modules/mdl0015.htm

Make a table for containing your data (navn, adresse ....) then make a form using the form wizard. You use the form fro entering data into your table.

Ince you have some data in the table try exporting the table. You can do this by right clicking on th etable and then choosing Export. Now find XML in the list and folow the guide. You can also work with XML files in code

Here are a few links concerning XML. You can be downloaded an XML parser here.

http://msdn.microsoft.com/XML/XMLDownloads/default.aspx



Some samples.

http://msdn.microsoft.com/XML/XMLCodeSamples/default.aspx



http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconxmldocumentobjectmodeldom.asp



This is an example I used for reading and xml file from Access.
In Access you will need a reference to Microsoft XML (Tools+References menu)

Function ReadXMLDoc()

Dim doc As MSXML2.DOMDocument

Dim nodes As IXMLDOMNodeList

Dim i As Integer

On Error GoTo Proc_ERR

    Set doc = CreateObject("msxml2.DOMDocument")

    doc.async = False

    doc.Load "C:\XMLTest.xml"

    Set nodes = doc.selectNodes("//invoice")

    Debug.Print nodes.length 'Number of nodes, with base = 0

    For i = 0 To nodes.length - 1

        Debug.Print nodes(i).Attributes.getNamedItem("date").Text

        Debug.Print nodes(i).childNodes(0).Text

        Debug.Print nodes(i).childNodes(1).Text

        Debug.Print nodes(i).childNodes(2).Text

        Debug.Print nodes(i).childNodes(3).Text

        Debug.Print nodes(i).childNodes(4).Text

    Next i 

End Function

Thanks a ton. I will test it and get back here afterwards

Hi Peter, hows it going, have you tried it yet?

Hi Terry

I have been sick all week... so I have not been able test your examples...

I have read through your examples but have only read through your examples one time and that is far from enough for me to understand the aproach.

I stumpled upon this link while googling (no idea why I did not find this before I wrote this post)

http://msdn.microsoft.com/office/understanding/access/techarticles/default.aspx?pull=/library/en-us/odc_ac2003_ta/html/odc_accessnewxmlfeatures.asp

Like your links I have not tested these methods, but it seem like importXml and exportXml are meant for solving some of this...

I will return here when I get better (and test the examples)

Sorry for keeping you waiting this long and thanks for checking back =)

Hi Peter, sorry to hear your ill, hopefully your feeling better before Xmas.
The link you gave explains how to import/export an XML file, but still you need to be able to send/receive the file from a web address. Thats if I have understood your question correctly. This is where FTP/HTTP comes in and the link I gave (http://www.mvps.org/access/modules/mdl0015.htm)
show you how to do this from Access.

Anyway, when your feeling better and have studied the examples, get back if you need further help.
Hope your well soon.

mvh og god jul
Terry

I am finally getting better even though I still have a slamming headache. Well enough about that and back to the problem at hand...

I do not know if it have an impact on the way to handle these things but the XML files have a SOAP tag. I am truly sorry if this change everything.

I have raised the points to 200 because of the long wait and the extra trouble.

I found out that I needed to use SOAP/Webservice instead of XML/FTP as I thought when I wrote the original question. I have been using lots of time looking through the links and suggestions posted by terry and they answer the question I had to begin with and is therefore accepted.


If someone else need help working with SOAP/Webservice in Access 2003 I can pass on the following link. The link have a good and simple guide on how to work with these things. I had to install the new version of ‘Webservice Toolkit’ as well (there is a link to this on the page).
http://www.microsoft.com/office/previous/xp/webservices/toolkit.asp

Thanks a lot Peter
I've been trying to reply to your mail all day, I keep getting an error. Hopefully the last on eI sendt from home will get through.
Once again thanks, and for the link too!