harshgupta
New member
- Local time
- Yesterday, 20:38
- Joined
- Feb 10, 2010
- Messages
- 4
Hi,
I am facing a problem regarding importing data from [COLOR=blue! important][COLOR=blue! important]XML[/COLOR][/COLOR] 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 [COLOR=blue! important][COLOR=blue! important]database[/COLOR][/COLOR] 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
I am facing a problem regarding importing data from [COLOR=blue! important][COLOR=blue! important]XML[/COLOR][/COLOR] 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 [COLOR=blue! important][COLOR=blue! important]database[/COLOR][/COLOR] 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