XML parsing, Nodes vs Attributes...

[TheCPUWizard]

The following will load into a SQL (2005) table perfectly:

<ValidateData>
<Validate Type="Countries" Name="CountryCode"
Value="JA" Test="Not Exists"/>
<Validate Type="Countries" Name="CountryCode"
Value="BO1" Test="Exists"/>
</ValidateData>


But my XML is of the form

<ValidateData>
<Validate>
<CountryCode>JA</CountryCode>
<Test>Exists</Test>
</Validate>
</ValidateData>


Wondering what is the best way to handle this????