create insert statements from xml file

[j***@gmail.com]

Hi all
I have a number of xml files which I need to extract data from and insert into various tables. I know that there has been a lot of xml functionality added to the last couple of versions of the engine but I can not find the commands/functions to do this conversion. What is the best way to approach doing something like this?

Thanks
Joe

[Ian Goddard]

Post by j***@gmail.com
Hi all
I have a number of xml files which I need to extract data from and insert into various tables. I know that there has been a lot of xml functionality added to the last couple of versions of the engine but I can not find the commands/functions to do this conversion. What is the best way to approach doing something like this?
Thanks

I had to do this for SQL Server <spit/> before such facilities had been
built in. I wrote an XSLT script to convert the XML into SQL statements
& then passed them to the engine to execute.

[Doug Lawry]

Quite easy with tools from www.altova.com.

Regards,
Doug Lawry