parse xml file and vbscript 
Author Message
 parse xml file and vbscript

I am wanting to parse an xml file and place the
information into a SQL database.  I used an xsl file to
step thru it and it prints to the screen, but I am unsure
of how to parse it and have it go into my SQL tables.

my xml file layout

<file>
  <batch id="1" date="01/01/03">
     <Org id="1" name="something">
        <fac id = 1 name="something" />
     </Org>
.....(More Orgs and other information)
  </batch>
</file>

Thanks,
Joe



Tue, 06 Sep 2005 20:57:24 GMT  
 parse xml file and vbscript
Hi Joe

I don't think any xml with multiple depths can be incorporated into a table
in structured way, if you mean it. Here, you may find a picture of xml which
goes/comes to and from the table.

http://msdn.microsoft.com/msdnmag/issues/1100/BeyondASP/default.aspx

--
Have a nice day.
Han Pohwan, Microsoft MVP(ASP), Korea


Quote:
> I am wanting to parse an xml file and place the
> information into a SQL database.  I used an xsl file to
> step thru it and it prints to the screen, but I am unsure
> of how to parse it and have it go into my SQL tables.

> my xml file layout

> <file>
>   <batch id="1" date="01/01/03">
>      <Org id="1" name="something">
>         <fac id = 1 name="something" />
>      </Org>
> .....(More Orgs and other information)
>   </batch>
> </file>

> Thanks,
> Joe



Wed, 07 Sep 2005 03:01:33 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. SAX XML parsing in VBScript?

2. HELP - I need to parse xml with vbscript

3. parse XML file

4. Parsing xml file

5. parse xml file into jscript object then into treeview object

6. Parsing XML from an ASP page that Creates XML fails

7. how to parse wml (xml) files

8. Parse RSS XML files (news feeds)

9. Reading/parsing an XML file into VB.

10. vb library/procedure for parsing html/xml/sgml like files

11. Parse external XML file in VBA

12. Parsing XML file in VB

 

 
Powered by phpBB® Forum Software