I am trying to read a whole Access database into Postgis using the ogr2ogr (Version 1.9.1) command.

For some reason however, it only reads spatial tables and no non-spatial tables. All my attempts to overcome this problem so far have failed^.

I have tried configuring options such as "-nlt None" or "SET PG_LIST_ALL_TABLES=YES"

How is it possible to read ALL tables and not only the spatial tables?

This is the command I've used:

ogr2ogr --config PG_LIST_ALL_TABLES YES -f "PostgreSQL" PG:"host=localhost user=postgres dbname=ele_schnottwil password=bsb port=5432" C:\ele.mdb -a_srs EPSG:21781 -overwrite -skipfailures

I know PG_LIST_ALL_TABLES is a Postgis driver command but I read this could be used for the ODBC driver, too.

Can anyone see the problem or help me out.

Thanks so much in advance.

Best regards, Arne

1 Answer 1


Upgrade to version 1.10 of GDAL/OGR (GDAL: ODBC RDBMS)

Starting with GDAL 1.10, and on Windows provided that the "Microsoft Access Driver (*.mdb)" ODBC 
driver is installed, non-spatial MS Access Databases (not Personnal Geodabases or Geomedia databases) 
can be opened directly by their filenames. 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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