Read xml file, store data in db. What could be easier?



OK guys,
I am going to receive an xml doc and am going to have to parse the data
values and store them in the database. About 10 db tables are targets for the
data, with repeating groups of data and such. I have not done this with Sql
Server before. I need to be pointed in the right direction. So start
pointing!

Thanks,

Michael
.



Relevant Pages

  • Re: Parsing and storing formulas
    ... you could easily store different views/stored ... >I was wondering how I can parse a mathematical formula in a storable way. ... > be stored for in the database. ... > The second idea is to represent the formula as a tree. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Using XML to serialize a SQL Query
    ... I understand that you need to parse the WHERE clause ... When I retrieve the rule from the database, I need some way to populate ... If I simply store it in the database as "Loan.Amount greater than 500000", ...
    (microsoft.public.dotnet.xml)
  • Re: Text indexing problem.
    ... to make a text indexer, which should parse a text file and store ... the important words and the count of their occurrence in a database. ...
    (comp.programming)
  • Re: Text indexing problem.
    ... which should parse a text file and store ... the important words and the count of their occurrence in a database. ... foreach my $word ...
    (comp.programming)
  • Re: how to convert word doc to xml and store in database
    ... xml doc in to a sqlserver database.. ... how to convert a word doc to xml and after retrieving that xml doc ... from database table how to back to word form and place it in a doc.. ... You can store your document as a BLOB in sql server. ...
    (microsoft.public.dotnet.languages.csharp)

Quantcast