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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Moving data from M$ JetDB file to Postgres on Linux
Date: 2014-03-01 00:19:36
Message-ID: 53112798.7010308@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/28/2014 03:58 PM, Rich Shepard wrote:
> On Fri, 28 Feb 2014, Adrian Klaver wrote:
>
>> The only software I could find to directly read MDB files on Linux is :
>> http://mdbtools.sourceforge.net/
>> Not sure what version of MDB you have and whether the above is current
>> enough to read them. Otherwise you need to crank up an Access instance
>> and go from there.
>
> Adrian,
>
> I have mdbtools which I used on Access files in the past. I was not
> aware
> that JetDB was the same data format.

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.

>
> Carpe weekend,
>
> Rich
>
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2014-03-01 00:33:23 Re: Moving data from M$ JetDB file to Postgres on Linux
Previous Message Thomas Kellerer 2014-03-01 00:10:43 Re: Moving data from M$ JetDB file to Postgres on Linux