[GRASS-user] Using Access .mdb Files

Stuart Edwards sedwards2 at cinci.rr.com
Tue Jan 11 16:37:59 EST 2011

I've been trying to crack this one recently too.  Not much success.  mdb-sqlite installs ok and the test case runs fine, but my mdb files seem to cause it to crash with a string of errors.  This behavior is noted by others and I haven't been able to reach the author.  One thing that was quite useful is a little freebie called AccessReaderAndWriter -


You need Windows  to run it but at least you can read the mdb file and extract some data manually.  PITA, but there we are.


On Jan 11, 2011, at 3:58 PM, Rich Shepard wrote:

> On Tue, 11 Jan 2011, Adam Dershowitz, Ph.D., P.E. wrote:
>> The .mdb file is a proprietary Microsoft Access format.
>  Yeah, I know that. We have compliance monitoring data from a client that
> we need to translate into our environmental information system. There are
> the mdbtools but I've not yet played with them ... successfully.
>> Here is some info about importing:
>> http://grass.osgeo.org/wiki/Data_formats#MicroSoft_Access
>> One option, mentioned there, is to convert it to sqlite then import.
>> These might help:
>> http://code.google.com/p/mdb-sqlite/
>> http://www.sqlite.org/cvstrac/wiki?p=ConverterTools
>  Thanks, Adam.
> Rich
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user

More information about the grass-user mailing list