General discussion

  • Creator
  • #2258389

    XML to Table


    by ian ·

    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 ???

All Comments

  • Author
    • #3210370


      by jaqui ·

      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.

Viewing 0 reply threads