Re: XML data extraction

Andrew Williams wrote: > 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 > Oh, I thought of another one: Write some XSL to turn you XML into SQL. Write some code to run that SQL. HTH Pete -- Peter Ford phone: 01580 893333 Developer fax: 01580 893399 Justcroft International Ltd., Staplehurst, Kent