The XML format that Excel is expecting, in order to automagically map a schema and import, is:

<record>
   <id>001</id>
   <Headline>New Item</Headline>
   <Owner>smith</Owner>
</record>
But the XML output from another application (ClearQuest) uses this format:

<exportedResults creationTime="Thu Aug 15 16:47:19 GMT 2013">
  <providerInfo name="ClearQuest" version="6.0.0.0"/>
  <queryInfo name="All Items" recordType="Defect"/>
  <columnNames>
    <columnName>id</columnName>
    <columnName>Headline</columnName>
    <columnName>Owner</columnName>
  </columnNames>
  <records>
    <record>
      <field name="id">001</field>
      <field name="headline">New Item</field>
      <field name="owner">smith</field>
    </record>
  </records>
</exportedResults>
If I have to implement a custom import script in VBA, I can certainly do that. But I was wondering if anyone has seen this format and solved the import problem already?

Thanks for looking and your comments.