General discussion

Locked

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.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

yup

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums