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

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: Moving data from M$ JetDB file to Postgres on Linux
Дата
Msg-id CAOzAquJ52aaHvJEr-aumE1GE=0ekD94wmPhnavr-TJUTr0CqBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Moving data from M$ JetDB file to Postgres on Linux  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Bret Stern
Дата:
Сообщение: Re: Moving data from M$ JetDB file to Postgres on Linux
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 'tuple concurrently updated' error when granting permissions