in reply to XML and Databases and Excel, Oh My!
I recommend avoiding XML if there's any way possible. Whenever I've had to do anything like this, I dump the data from the database into a CSV file. Excel (and its OpenOffice equivalent) can easily import/export CSV files.
But if you *have* to do XML stuff - XML::Parser can probably do whatever you need.
In Section
Seekers of Perl Wisdom