TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • July 11, 2006 at 12:37 am #2258389

    XML to Table

    Locked

    by ian · about 16 years, 11 months ago

    Daily I am being sent an XML File that I need to integrate straight into a MS SQL Table, so far all the code seems to crash…

    Is there a simple way ???

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • July 11, 2006 at 1:17 am #3210370

      yup

      by jaqui · about 16 years, 11 months ago

      In reply to XML to Table

      a simple 2 step way.
      write a script to turn the xml file’s divs into a comma delimited file and with the sql insert statements needed.

      run the output of the first script as an sql query against the data base.

      if the content of the xml file is to be directly put into the table, each div in the xml file is equal to a field in the db table.

  • Author
    Replies
Viewing 0 reply threads