[postgis-users] mdb files

[Mateusz Loskot]

Arnaud Lesauvage wrote:
> Will Muir a écrit :
>> Does anyone have any suggestions for dealing with mdb files, on 
>> either the Mac or Linux?  Preferably I would like to convert them to 
>> a Postgis database.  I see there is a package called mdbtools, though 
>> it does not seem to want to compile on the Mac and I have not tried 
>> on Linux yet.  But even if it does work will  the results be in a 
>> format that could be inserted into Postgis?
> 
> If this is only for a one-time use, maybe you could try some kind of
> virtual machine ?
> You don't even need MSAccess to open the mdb, you could write a script
> that would read it with an ADO or DAO connection.

On Windows, it should be sufficient to use ogr2ogr with ODBC driver to
load data from mdb file to PostgreSQL.

Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net