Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2010
    Posts
    1

    Question Unanswered: Problem in Importing XML data to access 2003-7 database

    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
    Last edited by harshgupta; 02-10-10 at 05:09. Reason: Getting smily

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •