Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -


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.

Related Discussions

Related Forums