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

Please Login or Register  to view this content.
But the XML output from another application (ClearQuest) uses this format:

Please Login or Register  to view this content.
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.