Help with XML / SAX Parser

Hey Guys

One of my vendors killed their csv download for product updates and now it's only XML. And it's a huge wonking XML file too, 20 MB and over 500,000 lines. XL07 can't read the schema. This thing has 25 or so data columns and XL07 can only parse 8 or so. Dreamweaver only sees 80K rows, Chrome, FF and IE all crash if I try to open it in them. I need some other program. I've read that maybe it can get sucked into SQL Srvr or mysql, but WHY the F do I have to mirror their db locally??

Their coder told me this:

The file is not meant to be opened with an XML editor. I suggest parsing it with a SAX parser. The entire file should take less than 5 minutes to parse on a fairly modern machine using any scripted language, faster with Java or C

Click to expand...

I don't know why this bozo thinks I've got C programmers just sitting around with nothing else to do, or that I want to spend time writing an app because THEY killed their perfectly useful text download. I had apps written around the old files to get the info I need and now all that work is trashed.

ANYWAY, I can't find a reasonable SAX parser GUI. I've found a couple links to php code that will be a pain in the ass to implement. WTF should my browser have to parse and open a 20 MB text file?

Tools at hand: enterprise and pro versions of vis studio 2008, sql srvr, cs4, office 07.

How can I parse this monster every few days and just get on with my life?? Any advice is appreciated! I'm at a loss

SAX is a difficult API to use because of its lack of random access, You may want to try some other XML API such as vtd-xml

http://vtd-xml.sf.net