XML data extraction

[Andrew Williams <andrew4williams@xxxxxxxxx>]

Best All,

How can you best and accurately extract  XLM data to DB table.  e.g.:

<EXCHANGE_LIST  AMOUNT="3">
-
<EXCHANGE>
<ID_EXCHANGE>20</ID_EXCHANGE>
<CODE_EXCHANGE>FRA</CODE_EXCHANGE>
<NAME_EXCHANGE>Frankfurt</NAME_EXCHANGE>
</EXCHANGE>
-
<EXCHANGE>
<ID_EXCHANGE>28</ID_EXCHANGE>
<CODE_EXCHANGE>LSE</CODE_EXCHANGE>
<NAME_EXCHANGE>London Stock Exchange</NAME_EXCHANGE>
</EXCHANGE>
-
<EXCHANGE>
<ID_EXCHANGE>226</ID_EXCHANGE>
<CODE_EXCHANGE>GER</CODE_EXCHANGE>
<NAME_EXCHANGE>Xetra</NAME_EXCHANGE>
</EXCHANGE>
</EXCHANGE_LIST>

www.willandy.co.uk