Read XML file from web source

alsol

Hello there,

Is it possible to read XML data from a web resource? I would like to develop an import routine to read the published exchange rates on a daily base from the following source:

http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/wechselkurse.php

Any ideas how this could be done? Of course I could manually save the file and then read it from NAV but can this be done directly?

Best regards

ara3n

I suggest to look at MSxmldom automation and use it to get the xmlfile and either use xmlport to parse it or use msxmldom itself to loop through the nodes.