[RESOLVED] Easy question - I hope - XML Parsing.

[silentthread]

Hi all,

I have to parse an xml structure and place it in an excel table.
It only has 2 levels and the structure is already table friendly.
What would you say would be the best way to do this?

Once I have the data, I will write it out to a csv file, and open it in excel.
But my main concern is parsing the xml structure. I hope I don't need to do a readline, and search for index of <member>, etc. :-(


Here is the structure....

[CODE]
<main>
<member>
<name>bubba</name>
<lastname>smash</lastname>
</member>
<member>
<name>joe</name>
<lastname>smash</lastname>
</member>
</main>CODE]

[silentthread]

Even better if there is a free tool that can convert this structure to a table.

[silentthread]

Resolved. All I had to do was try to open the xml file in Excel and let Excel try to create a schema for it.