XML File into a SQL table

6 Dec 2006 12:17 PM

AMP

I have a XLM file that contains data, but no schema, How can I read
this data into a SQL table (this has the correct colums etc

6 Dec 2006 2:01 PM

rowe_newsgroups

> XLM

I guessing you mean XML

One way would be to parse it manually with the XmlReader or XmlDocument
classes and then hit your table with SQL Insert commands.

Let me know if you need me to elaborate

Thanks,

Seth Rowe

AMP wrote:
Show quoteHide quote

> I have a XLM file that contains data, but no schema, How can I read
> this data into a SQL table (this has the correct colums etc

6 Dec 2006 4:14 PM

zacks

rowe_newsgroups wrote:

> > XLM
>
> I guessing you mean XML
>
> One way would be to parse it manually with the XmlReader or XmlDocument
> classes and then hit your table with SQL Insert commands.
>
> Let me know if you need me to elaborate

I wonder why anyone would go to such trouble with XMLSerialization is
so easy to use?

Show quoteHide quote

>
> Thanks,
>
> Seth Rowe
>
>
> AMP wrote:
> > I have a XLM file that contains data, but no schema, How can I read
> > this data into a SQL table (this has the correct colums etc

6 Dec 2006 4:30 PM

rowe_newsgroups

> I wonder why anyone would go to such trouble with XMLSerialization is
> so easy to use?

When the OP said "contains data, but no schema" I took that as meaning
it wouldn't deserialize properly. Besides, depending on that how the
XML file is structured, a few well built for loops could run through
the file fairly easily.

Oh well, I guess there's more than one way to skin a cat :-)

Thanks,

Seth Rowe

za***@construction-imaging.com wrote:
Show quoteHide quote

> rowe_newsgroups wrote:
> > > XLM
> >
> > I guessing you mean XML
> >
> > One way would be to parse it manually with the XmlReader or XmlDocument
> > classes and then hit your table with SQL Insert commands.
> >
> > Let me know if you need me to elaborate
>
> I wonder why anyone would go to such trouble with XMLSerialization is
> so easy to use?
>
> >
> > Thanks,
> >
> > Seth Rowe
> >
> >
> > AMP wrote:
> > > I have a XLM file that contains data, but no schema, How can I read
> > > this data into a SQL table (this has the correct colums etc