Database help needed

Amber amber.of.luxor at
Mon May 4 19:30:32 EDT 2009

My PHB is insane.

Today he drops 50,000 databases in MS Access format on my desk, and tells me
that by Friday I need to:
* Remove all of the "junk content" in the record fields;
* Remove all records with blank fields in them;
* Correct all fields in which the markup is "wrong";
* Correct all fields in which the data is "wrong";
* Ensure that all database include some specific tables;
** Add appropriate content to the records in the "new" tables;

And finally, said databases are to be in:

* MS Access 97 format;
* MS Access 2000 format;
* MS Access 2003 format;
** Is there any documentation anywhere on what the differences between those
is?   Won't a database created for Access 97 be openable in MS Access 2003?
* SQLite format;
* MySQL format;
* PDB format, for use on his PalmPilot;
* Commas separated values;
* dBase 3;
* Excell spreadsheets;
* ODF spreadsheets;

I'm a programming novice, but I think that I can write a script that reads
the MSAccess databases, and cleans up the content in the individual fields
of the database.
What I need is:
* A pointer to good. current, downloadable documentation on creating, and
editing databases using Python;
** Good current books on python and databases will also be useful;
* Pointers to material that describe how to create MS Access databases using
Python, on Linux;
* Pointers to material that describe how to create, and edit SQL CE 2.0
databases in Python, on Linux.  I'm assuming that this is possible, but
since that database engine is available for Windows Mobile only --- at least
according to the Google search I did --- I have some doubts;

I need stuff I can download.   I'll be burning it to a DVD, and taking that
to work.   No internet access at work.  The PHB considers that to be a time
waster, and an expensive luxury that can not be justified in the current
economic climate.

Wind under Thy Wings
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Python-list mailing list