2
Hi I have an XML file with the following data pattern
<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'>
<s:AttributeType name='seq' rs:number='1' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='str' dt:maxLength='3' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='MechaNo' rs:number='2' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='30' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ScannerNo' rs:number='3' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ProductionStartTime' rs:number='4' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='SafetyTime' rs:number='5' rs:writeunknown='true'>
<s:datatype dt:type='datetime' rs:dbtype='datetime' dt:maxLength='50' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='SafetyResult' rs:number='6' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row seq ='1' MechaNo = 'MAY11002M087Y29309' ScannerNo ='C68978200S467Z03501' ProductionStartTime = 'NULL' SafetyTime = '12 Feb 2008 08:25:42 AM' SafetyResult='OK'/>
<z:row seq ='2' MechaNo = 'MAY11002M167Y29290' ScannerNo ='C68978200S467Z03491' ProductionStartTime = 'NULL' SafetyTime = '12 Feb 2008 08:26:14 AM' SafetyResult='OK'/>
</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
