Click to See Complete Forum and Search --> : xml to sql database


yossya
May 10th, 2003, 12:02 PM
i have an urgent problem!
i need to generate sql server tables from xml file.i've created an xml file and xsd for it.there is an option to view a dataset from this xsd.
my question is:
is there a way to turn this dataset view into a create table command in sql server?
could someone write me an example code that does it?
thanks in advance

pareshgh
May 16th, 2003, 06:47 PM
so you are looking for the sample which will show you
how to read/write XML files using DataSet ?

-Paresh

yossya
May 17th, 2003, 03:24 PM
not exactlly my question is how to load a dataset xml to the sql server.
thanks
yossy