Stefan Keller wrote:
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)?
Stefan,
The OGR PGeo and ODBC drivers are read-only. If you want to update
a geodatabase you will need to find another route, or just route
low level SQL through the ODBC driver using ExecuteSQL().
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, [email protected]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
