0

In osgeo4w I am uploading an mdb into postgis. It works perfectly with all the geometry content within the personal geodatabase, but it does not take the tables from the personal geodatabase.

Is there any way of adding some functionality to the following osgeo4w command in order to also extract the non geometry tables from the personal geodatabase?

ogr2ogr -overwrite -f "PostgreSQL" PG:"host=... dbname=... user=... password=..." filename.mdb

UPDATE

When using ogrinfo it does not recognize tables without a geometry. They are in the .mdb when you open it in Arcmap.

ogrinfo filename.mdb
1

You can access non-spatial .mdb tables through the ODBC driver.

In my experience, it is tricky depending on 32-bit, 64-bit, additional Windows installs and configuring ODBC data sources. I'm not sure if this will work with OSGeo4W, you may need the appropriate binaries from GIS Internals. You can see additional information that hints at some of this on the GDAL list and this ticket. Unfortunately, I don't know more specific information that would help you and that would be highly specific to the architecture of your machine and installs anyway, for myself I've both succeeded and failed at this.

|improve this answer|||||
0

Zuenie,

If you have PostgreSQL installed on windows, check out the recently released PostGIS 2.2.0 windows bundle available on stackbuilder and http://postgis.net/windows_downloads .

It comes packed with ogrfdw foreign data wrapper (which uses GDAL 2.0.1 shipped with PostGIS 2.2). We bundled ODBC support in it because we needed it for accessing non-spatial MS access dbs.

Here is an article describing how to use it:

http://www.postgresonline.com/journal/archives/346-Querying-MS-Access-and-other-ODBC-data-sources-with-OGR_FDW.html

Like I said, If you have PostGIS 2.2 both 32bit/64bit (PostgreSQL 9.3+) you can use it.

|improve this answer|||||

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.