[gdal-dev] Howto convert a CSV with geometry and a CVS without into one Geodatabase (.mdb)?

[Stefan Keller]

Dear all

I'm trying something new to me: I have two comma separated value files
(CSV, from an Excel user naturally :->) - one file having a lat and a
lon column.

The target database is a Geodatabase (.mdb) which not only has a
feature class table (fctable) but also another 'normal' MS Access
table (without geometry). The columns of the CSV with la/lon goes to
the fctable and the other CSV goes to othertable.

One of the challenges here is that othertable can't be accessed
through PGeo driver AFAIK.

In addition - after inserting a row into the fctable with a new oid -
there should be a foreign key added to othertable which establishes a
relationship from othertable to fctable.

=> How do I shuffle these CSVs into this Geodatabase (preferrably with Python)?
=> Has anyone accomplished a similar conversion (using Python or other scripts)?

Regards, Stefan