Hi I have an XML file with the following data pattern
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='seq' rs:number='1' rs:writeunknown ='true'>
<s:datatype dt:type='number ' rs:dbtype='str' dt:maxLength='3 ' rs:fixedlength= 'true' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='MechaNo' rs:number='2' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='3 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='ScannerNo ' rs:number='3' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='5 0' rs:fixedlength= 'true' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='Productio nStartTime' rs:number='4' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='5 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='SafetyTim e' rs:number='5' rs:writeunknown ='true'>
<s:datatype dt:type='dateti me' rs:dbtype='date time' dt:maxLength='5 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='SafetyRes ult' rs:number='6' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='1 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row seq ='1' MechaNo = 'MAY11002M087Y2 9309' ScannerNo ='C68978200S467 Z03501' ProductionStart Time = 'NULL' SafetyTime = '12 Feb 2008 08:25:42 AM' SafetyResult='O K'/>
<z:row seq ='2' MechaNo = 'MAY11002M167Y2 9290' ScannerNo ='C68978200S467 Z03491' ProductionStart Time = 'NULL' SafetyTime = '12 Feb 2008 08:26:14 AM' SafetyResult='O K'/>
</rs:data>
</xml>
I want to upload the record in the xml Pattern like Mechano, ScannerNo etc onto sql Server
I used to VB 6
anybody help me Please
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='seq' rs:number='1' rs:writeunknown ='true'>
<s:datatype dt:type='number ' rs:dbtype='str' dt:maxLength='3 ' rs:fixedlength= 'true' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='MechaNo' rs:number='2' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='3 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='ScannerNo ' rs:number='3' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='5 0' rs:fixedlength= 'true' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='Productio nStartTime' rs:number='4' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='5 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='SafetyTim e' rs:number='5' rs:writeunknown ='true'>
<s:datatype dt:type='dateti me' rs:dbtype='date time' dt:maxLength='5 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:AttributeTyp e name='SafetyRes ult' rs:number='6' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str' dt:maxLength='1 0' rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row seq ='1' MechaNo = 'MAY11002M087Y2 9309' ScannerNo ='C68978200S467 Z03501' ProductionStart Time = 'NULL' SafetyTime = '12 Feb 2008 08:25:42 AM' SafetyResult='O K'/>
<z:row seq ='2' MechaNo = 'MAY11002M167Y2 9290' ScannerNo ='C68978200S467 Z03491' ProductionStart Time = 'NULL' SafetyTime = '12 Feb 2008 08:26:14 AM' SafetyResult='O K'/>
</rs:data>
</xml>
I want to upload the record in the xml Pattern like Mechano, ScannerNo etc onto sql Server
I used to VB 6
anybody help me Please