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

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving data from M$ JetDB file to Postgres on Linux
Date: 2014-03-01 14:03:31
Message-ID: alpine.LNX.2.00.1403010559090.17426@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 1 Mar 2014, Vincent Veyron wrote:

> I've had success with mdbtools, but on older version of Jet database files
> and small files. I've haven't tested it on Access 2007+.

Vincent,

I suspect this file is in the current Access version.

> I understand you run linux, but if you can get hold of a Windows machine
> with Access on it, or find someone who does, you can always export to text
> and use that. You can use recent versions of the software to open older
> files usually.

Of course. :-) But, I don't know anyone (other than my sister) who uses
Windoze so I decided to look for a different data set.

The specific data do not matter, I need them for sample analyses for a
short course I'll be offering. My only criteria are the data be
environmental rather than economic, medical, or social and that I do not use
any client's data.

There's lots of public domain data on the Web so I'll find something
useful.

Much appreciated,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-03-01 14:38:39 Re: 'tuple concurrently updated' error when granting permissions
Previous Message Vincent Veyron 2014-03-01 11:33:58 Re: Moving data from M$ JetDB file to Postgres on Linux