Re: Converting Access .mdb to postgres - Mailing list pgsql-general

From Rich Shepard
Subject Re: Converting Access .mdb to postgres
Date
Msg-id alpine.LNX.2.20.1908141046010.17042@salmo.appl-ecosys.com
Whole thread Raw
In response to Converting Access .mdb to postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Converting Access .mdb to postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
List 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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Converting Access .mdb to postgres
Next
From: Rich Shepard
Date:
Subject: Re: Converting Access .mdb to postgres