newbie question: Convert XML to a table.

[Lokean]

Sorry for this newbie question, this is not my realm of expertese.
I have searched google, tried several applications that claim they can do this, such as Mapforce, which I found confusing, to Oxygen, to HTML kit, et cetera.

I am more confused than ever.

here's my quandry.

I was sent a file and told that we need to get the data into a more readable form.

I've tried using apps to pull it in, but it's not displaying properly.

I just need to get this to appear as a table. web, SQL table, it doesn't matter.

Here is the basic structure of the table

<Snapshot device="Device name" model="Model" version="1">
−
<node name="FOO">
−
<table name="Table1">
−
<row>
<column name="COL1">'+SYS'</column>
<column name="COL2">'1234'</column>
<column name="COL3">'+'</column>
<column name="COL4">0</column>
<column name="COL5">5</column>
<column name="COL6">50</column>
<column name="COL7">1</column>
<column name="COL8">1</column>
<column name="COL9">0</column>
<column name="COL10">0</column>
<column name="COL11">1</column>
<column name="COL12">0</column>
<column name="COL13">0</column>
<column name="COL14">1</column>
<column name="COL15">1</column>
<column name="COL16">0</column>
<column name="COL17">0</column>
<column name="COL18">0</column>
<column name="COL19">0</column>
<column name="COL20">1</column>
<column name="COL21">15</column>
<column name="COL22">1</column>
<column name="COL23">388</column>
<column name="COL24">2</column>
</row>
.
.
.
.
.
.

</table>
</node>
</Snapshot>


Again, I apologize for the newbie question.
I have about 130K rows that I need to convert into a table.

I've tried Access, Excel and a few other applications to try to do a quick parse. XML is not my strong suit

I don't know how to turn this into a table that would be viewable. Any suggestions?

[jkmyoung]

The least technical solution would be to use Excel 2003 or later to convert it into a spreadsheet, then save it to html format.

The 2nd least technical solution would be to use xsl to convert it into a table like html form, but that'd require a little work.

Check your version of Excel first.

[Lokean]

The least technical solution would be to use Excel 2003 or later to convert it into a spreadsheet, then save it to html format.

The 2nd least technical solution would be to use xsl to convert it into a table like html form, but that'd require a little work.

Check your version of Excel first.

I've tried Excel(2003), the file is just too big for excel.

[jkmyoung]

With bigger files, I would stay away from any xml processing that involves DOM, eg XSLT. Are you much of a programmer? If so pick a language, and we can probably start from there.

Suggested languages, PHP, C#, Java