XML Help

[krooga]

Hi guys,
I need your help concerning a XML question...

I have received a database in XML format from a music label with all their catalog (8000 tracks).
I would need to view this information in a structured manner or in a form in order to be able to analyse the product much clearly.

An example of the XML file is as follows:
- <PRODUCT product_id="2000158" product_artist="Steve Murano" product_title="Passion" product_genre="Dance" ean="4029758493755" upc="881226006928" cover_uri="2000158" label="Kontor Records" media_type="Maxi Single" product_pricecode="B" available_territories="+WW" product_c_line="© 2003 Kontor Records GmbH">
<TRACK track_id="1000909" track_artist="Steve Murano" track_name="Passion (Radio Edit)" isrc="DEN060300829" duration="0:03:29" track_uri="1000909" track_genre="Dance" track_setno="1" track_no="1" track_author="Bobby Orlando" track_publisher="Universal Music" track_c_line="© 2003 Kontor Records GmbH" track_p_line="(p) 2003 Dance All Day Musicvertriebs GmbH – Germany / Kontor Records GmbH" track_explicit_flag="n" />
<TRACK track_id="1000910" track_artist="Steve Murano" track_name="Passion (Vocal Club Mix)" isrc="DEN060300802" duration="0:09:14" track_uri="1000910" track_genre="Dance" track_setno="1" track_no="2" track_author="Bobby Orlando" track_publisher="Universal Music" track_c_line="© 2003 Kontor Records GmbH" track_p_line="(p) 2003 Dance All Day Musicvertriebs GmbH – Germany / Kontor Records GmbH" track_explicit_flag="n" />
<TRACK track_id="1000911" track_artist="Steve Murano" track_name="Passion (Original Club Mix)" isrc="DEN060300803" duration="0:08:39" track_uri="1000911" track_genre="Dance" track_setno="1" track_no="3" track_author="Bobby Orlando" track_publisher="Universal Music" track_c_line="© 2003 Kontor Records GmbH" track_p_line="(p) 2003 Dance All Day Musicvertriebs GmbH – Germany / Kontor Records GmbH" track_explicit_flag="n" />
<TRACK track_id="1000912" track_artist="Steve Murano" track_name="Passion (Maiwald & Fiedler Remix)" isrc="DEN060300804" duration="0:07:47" track_uri="1000912" track_genre="Dance" track_setno="1" track_no="4" track_author="Bobby Orlando" track_publisher="Universal Music" track_c_line="© 2003 Kontor Records GmbH" track_p_line="(p) 2003 Dance All Day Musicvertriebs GmbH – Germany / Kontor Records GmbH" track_explicit_flag="n" />
</PRODUCT>


How can I go implementing this in a nice and easy to read page, form or access or excel database ?

Please help

[M0rtym0use]

krooga,
you could use an xsl style sheet if you only want to view the data in say a table, http://www.w3schools.com/xsl/xsl_languages.asp should be enough info here to do what you require

alternatively you could import it into a database and query the db...

MM