1

I need to convert a PostGIS table to a personal geodatabase using ogr2ogr. I can convert tables to a shapefile without a problem but whenever I try to convert it to .mdb using the ODBC driver, I get an error. I have got the 64-bit GDAL version and also the 64-bit ODBC driver installed.

This is my command:

ogr2ogr -f "ODBC" C:\users\[user]\file.mdb PG:"host=localhost user=[user] dbname=[db] password=[password]" "[tablename]"  

This is the error I get:

ODBC driver failed to create C:\users\[user]\file.mdb

Am I using the right command to do this, or am I missing a driver or something?

2

Per the docs:

Currently the ODBC OGR driver is read-only, so new features, tables and datasources cannot normally be created by OGR applications.

Additionally, neither the PGeo nor MDB drivers support creation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.