XML File into a SQL table

  • Thread starter Thread starter AMP
  • Start date Start date
A

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
 
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
 
rowe_newsgroups said:
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
Click to expand...

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

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
 
Back
Top