Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving data from M$ JetDB file to Postgres on Linux - Mailing list pgsql-general

From Michael Nolan
Subject Re: Moving data from M$ JetDB file to Postgres on Linux
Date
Msg-id CAOzAquJ52aaHvJEr-aumE1GE=0ekD94wmPhnavr-TJUTr0CqBQ@mail.gmail.com
Whole thread Raw
In response to Moving data from M$ JetDB file to Postgres on Linux  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
I think that PHP has modules (eg, PEAR) that can read MS Access database files, and once you have it in an array you can create INSERT statements for PostgreSQL, including cleaning up any data format issues (eg, dates of 00-00-0000)
--
Mike Nolan


On Fri, Feb 28, 2014 at 6:21 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
  I just downloaded two scientific data files from a federal agency's Web
site. Both are in M$ JetDB format. I run only linux and keep all my
scientific dat in postgres.

  My Web search did not turn up anything useful; the closest was a thread
from this mail list in 2000 on how to send a postgres query through odbc to
an Access database.

  Is there a filter I can use to get the data from these files?

TIA,

Rich



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Bret Stern
Date:
Subject: Re: Moving data from M$ JetDB file to Postgres on Linux
Next
From: Tom Lane
Date:
Subject: Re: 'tuple concurrently updated' error when granting permissions