Discussion Locked

XML to Table

0 helpful

1 reply

by ian Jul 11, 2006 last reply Jul 11, 2006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

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.

This discussion is closed to new replies.