Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Flattening Access DB to XMLby inman (Curate) |
on Jan 26, 2004 at 10:03 UTC ( [id://324107]=perlquestion: print w/replies, xml ) | Need Help?? |
inman has asked for the wisdom of the Perl Monks concerning the following question:
I am faced with the task of iterating through a substantial set of MS Access databases (*.MDB) files and, without knowing anything about their schema, writing out an XML file containing all of the table contents. The idea being that I can then run a search engine spider over the resulting XML files such that I can locate databases on the file system. This is part of a data discovery tool used for risk management.
I am seeking the wisdom of fellow monks with this task because I believe that I am not the only one to have needed to do this. I am also looking for an example of how to discover the schema of an MS Access database. The plan so far:
Any help on the 'Discover the Schema' bit would be most appreciated.
Back to
Seekers of Perl Wisdom
|
|