[GRASS-user] Using Access .mdb Files

[Stuart Edwards]

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 -

http://www.softpedia.com/get/Internet/Servers/Database-Utils/Access-Reader-And-Writer.shtml

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.

Stu

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