Thread: MS Access conversion utility

Hi,

I recently installed PostgreSQL 6.5.1 on SuSE 6.3 Linux system.
Everthing works fine. I have to transfer a lot of MS Access 97 tables
and queries to my new database system.
Has anybody an idea how to achieve this best? Are there any utlities on
the web?

Any hints are welcome.

Thanks in advance.
Oliver
--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.eunet.at/vecernik

I think you can do it with http://www.pgadmin.freeserve.co.uk/
or http://ds.dial.pipex.com/boylesa/pgupt/pgupt.shtml

Poul L. Christiansen
Oliver Vecernik wrote:

> Hi,
>
> I recently installed PostgreSQL 6.5.1 on SuSE 6.3 Linux system.
> Everthing works fine. I have to transfer a lot of MS Access 97 tables
> and queries to my new database system.
> Has anybody an idea how to achieve this best? Are there any utlities on
> the web?
>
> Any hints are welcome.
>
> Thanks in advance.
> Oliver
> --
> VECERNIK Datenerfassungssysteme
> A-2560 Hernstein, Hofkogelgasse 17
> Tel.: +43 2633 47530, Fax: DW 50
> http://members.eunet.at/vecernik

Install the PostgreSQL ODBC stuff on the/a Windows machine.  Create links
to Pgres tables from within the access database and just push the data,
row for row, into PostgreSQL.  It's easy, but it's manual.

Damond






Oliver Vecernik <vecernik@aon.at>
Sent by: pgsql-novice-owner@hub.org
07/09/2000 05:33 AM


        To:     pgsql-novice@postgresql.org
        cc:
        Subject:        [NOVICE] MS Access conversion utility


Hi,

I recently installed PostgreSQL 6.5.1 on SuSE 6.3 Linux system.
Everthing works fine. I have to transfer a lot of MS Access 97 tables
and queries to my new database system.
Has anybody an idea how to achieve this best? Are there any utlities on
the web?

Any hints are welcome.

Thanks in advance.
Oliver
--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.eunet.at/vecernik