Re: Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 9:34 GMT+09:00 Rich Shepard <rshepard(at)appl-ecosys(dot)com>:
> On Fri, 28 Feb 2014, Adrian Klaver wrote:
>
>> Well JET is the database engine for Access and mdb is one of the file
>> format extensions for Access database files. JET has been used in other MS
>> products and Access has used different file formats(extensions) over the
>> years. So you may be in for a chore depending on what files you actually
>> have. Might be worth it to do some exploring and see if the data is
>> available in a more useable form.
>
>
> Adrian,
>
> I'll try my mdbtools and see if there's a more current version.
>
> The data came from the USGS and they have it in only one format,
> unfortunately.

Not sure if this will be of use, but there are a couple of links here:

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access

I'll post it anyway in case someone comes across this thread in the future.

Regards

Ian Barwick