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.
Regards
Liz
Subject:Exporting XML to SQL Author:Liz Stanley Date:24 Oct 2005 09:24 AM
Thanks for replying Yuriy
The actual XML is over 10meg so I've made a cut down version - hopefully I've only deleted data and nothing vital!
Here it is:
prompts for the tables "Destinations" and "Characters"
if this is the case, you will probably have to write C++, C# or Java application to perform this job. Stylus Studio does not support multiple table inserts.