XML File into a SQL table

[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

 

[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

 

[zacks]

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?

 

[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