XML Parser???

[jimcheng]

Hi,

I need to parse some XML file and dump the data into database. What is the best tool/language to do it? How about visual basic?
Cause I already write some small VBA program to extract data from some software and output it into XML files.

Thanks!

Jim Cheng

[Ritu Raj Tiwari]

Java has probably the best APIs for parsing/manipulating XML. If you want scripting convenience, you could use Perl's XML parsing framework. Both also have convenient APIs for database access. Java's JDBC is probably better than Perl's DB access in that it is more standard and most DB servers come with JDBC drivers. VB would tie you to Win32.

-Tiwari

[S BUTLER]

You can use VB with the MSXML3 parser. This dll
transforms the file to a DOM (Document Object Model). Additionally the parser provides programming acces to the SAX (more of an inline parser). I have used both of these in a corporate environment with success.