I don't have much experience in compact xml, but this may work:
Questions the attribute Char="9" what does it mean? Well whatever it means
we can use that as the delimiter.  Assuming it means 9 spaces (which is not
the case!!)

you can write an xsl to extract the info contained in this xml and transform
the content to a csv file.  The key will be in modifying char="9" delimiter
to ","
your csv file can then be imported into access or any other db.

good luck
Skar
"Paul de Vries" <paul.de.vries@t...> wrote in message
news:QPgrd.6071$_F1.357467@p......
> hi guys, i got a weird thing
>
> some server gives back COMPACT XML
>
> that means
>
> <ROOTNODE>
> <DELIMITER Char="9"/>
>     <COLUMNS>    Column1    Column2    Column3    Column4    Column5
> </COLUMNS>
>     <DATA>    Data1    Data2    Data3    Data4    Data5    </DATA>
>     <DATA>    Data11    Data21    Data31    Data41    Data51    </DATA>
>     <DATA>    Data12   Data22   Data32    Data42    Data52    </DATA>
>     <DATA>    Data13    Data23    Data33    Data43    Data53    </DATA>
>     <DATA>    Data14    Data24    Data34    Data44    Data54    </DATA>
>     <DATA>    Data15        Data35        Data54    </DATA>
> </ROOTNODE>
>
> I understand this schema myself, but how can i
>
> how would i be able to store this information in a database, either
MS-SQL,
> Microsoft Access
>
> thanx for brainstorming with me
>
> grtz, Paul
>
>