I'm trying to import a xml file but I have been searching for days to find some code to help me understand what to do.
<?xml version="1.0" ?>
<xml ReflCompanyCode="01" ReflFileCreationTime="28/05/09 15:46:18" ReflTableName="ttItemExport" ReflUserFullName="Fop Halkema" encoding="UTF-8" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:z="#RowsetSchema">
<schema id="RowsetSchema">
<s:ElementType content="eltonly" name="row">
<s:AttributeType basecolumn="_iLine" name="_iLine" rs:nullable="true" rs:number="1" rs:writeunknown="true">
<sataType dt:maxLength="8" dt:type="I4" rsrecision="8"/>
</s:AttributeType>
<s:AttributeType basecolumn="" name="_Company_obj" rs:nullable="true" rs:number="2" rs:writeunknown="true">
<sataType dt:maxLength="17" dt:type="float" rsrecision="0"/>
</s:AttributeType>
<s:AttributeType basecolumn="_RecordValue" name="_RecordValue" rs:nullable="true" rs:number="3" rs:writeunknown="true">
<sataType dt:maxLength="8" dt:type="string"/>
</s:AttributeType>
<s:AttributeType basecolumn="Color" name="ColorCode" rs:nullable="true" rs:number="4" rs:writeunknown="true">
<sataType dt:maxLength="6" dt:type="string"/>
</s:AttributeType>
<s:AttributeType basecolumn="Color Description" name="ColorDescr" rs:nullable="true" rs:number="5" rs:writeunknown="true">
<sataType dt:maxLength="60" dt:type="string"/>
</s:AttributeType>
<s:extends type="rs:rowbase"/>
</s:ElementType>
</schema>
<rs:data>
<z:row ColorCode="21" ColorDescr="Rood" _Company_obj="5086.03472" _RecordValue="" _iLine="1"/>
</rs:data>
</xml>

I tried
Set xmlSource = CreateObject("MSXML.DOMDocument")
Set xmlXForm = CreateObject("MSXML.DOMDocument")

xmlSource.Load "test.xml"
xmlXForm.Load "sja.xsl"

strResult = xmlSource.transformNode(xmlXForm)

but then I get an error that there are no document elements. Therefor I think that this xml file is not readable using the above mentioned code.

Any suggestion how to read the xml file?