Hi,

I'm attempting to read in an XML file that is created by Microsoft's SQL Server Reporting Services export to XML function.

This code is what I have tried:

m.loDom = CREATEOBJECT('MSXML2.DomDocument.4.0')
m.loDOM.loadXML(GETFILE("XML"))
?m.loDom.xml

but I get nothing displayed on the screen. loDom.xml shows up as empty in the debugger too.

How do I upload the XML file I am trying to import?

Is it that the XML is invalid?

FWIW I tried reading it in using the XML Adapter, but got the message that the schema was too complex.

If anybody has any ideas how I can take this file and get its data into a VFP cursor, I would appreciate it.