Subject:Exporting XML to SQL Author:Liz Stanley Date:24 Oct 2005 09:18 AM Originally Posted: 24 Oct 2005 06:06 AM
I'm new to XML and StyleStudio so I apologise if I'm asking a really stupid question. I have to convert an XML file created by one of our suppliers to SQL. I thought I would create a dummy SQL table with just a few of the fields to test importing the XML but I'm falling at every hurdle.
In an ideal world I would like the XML to create the table and populate it - is this possible?
I found a very helpful posting by Ivan Pedruzzi that talked me through bulk loading an XML file into a single table but I get "Document root element is missing" when I run it.
Thanks in advance for any help.