the original table or view that contains the data is

centercode centername
---- ----
afjasdf akjhfdaksdh
adkfjhaskjd akhfkajsdh

etc

when exported to xml using adodb.recordset persistxml method in vb 6.0

<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">
- <s:AttributeType name="centercode" rs:number="1" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="centername" rs:number="2" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="100" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
<rs:data>
<z:row centercode="601" centername="Ganga nagar MSK Day BC -1" />
<z:row centercode="602" centername="Pattan MSK Day BC -2" />
<z:row centercode="603" centername="Shantinagar MSK Residential -1" />
<z:row centercode="604" centername="Kadane GPSS Day BC-1" />
</rs:data>
</xml>

This is the xml genrated out of my vb6.0 application this xml has to be
used in the .net application at some other site the xml we get should be interpreted and
be stored in appropriate table

in which the columns of the table are
centercode ,centername

the dataset i recieve should be validated and the table or view at the end of the

how can we do this can somebody give me headstart

or a sequence of instructions to follow for this conversion

the major problem with the xml generated out ot vb6.0 and sql is that it uses the XSD schema is there some class or method to directly import the data from this xml without using any intermediate style sheets or schemas