Re: Converting Access .mdb to postgres

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Converting Access .mdb to postgres
Date: 2019-08-14 17:55:25
Message-ID: alpine.LNX.2.20.1908141046010.17042@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 14 Aug 2019, Roger De Four wrote:

> The easy way - just send it to me.
>
> The more challenging way requires using several tools like excel or Open
> Office.

Roger,

I could post the .mdb on a cloud web site for download; it's 565M
uncompressed; the xz-compressed tarball is a mere 42M.

When I ran mdb-export I seleted postgres output. The tables are all insert
into statements of the data. I don't know that LibreOffice would handle
files of 112M (the size of one table as downloaded from their web site), but
emacs had no issues with it. 'Excel' or any other proprietary application is
not an option for me. I defenestrated early in 1997 and run only linux.

Will post the URL for the tarball Real Soon Now.

Thanks,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-08-14 18:01:18 Re: Converting Access .mdb to postgres
Previous Message Adrian Klaver 2019-08-14 17:49:39 Re: Converting Access .mdb to postgres