Hi,

I am facing a problem regarding importing data from XML to access database.

Part of Sample XML:-

<Credit
<CreditDt>2011-11-13</CreditDt>
<CreditSCd>AC</CreditCd>
<NumericValue>
<FormatText id="AADEE">string</FormatText>
</NumericValue>
<SecondaryCd>Shot</SecondaryCd>
</Credit>
<Credit>
<CreditDt id="AAGFC">1979-10-19</CreditDt>
<CreditCd>AC</CreditCd>
<NumericValue id="AAGFD">
<FormatInteger>-5638</FormatInteger>
</NumericValue>
<SecondaryCd>CR</SecondaryCd>
</Credit>

Now when i am importing data into access database it is forming the table NumaricValue with first column as FormatText but when this node is again occuring with different child node FormatInteger then this colummn is not getting appended in the table.

Which is leading to loss of data for the column FormatInteger as this column is not formed.

Please suggest any solution for the same