Re: Conversion from MS Access to Postgresql

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: "G(dot)L(dot)Lim" <limgl(at)grouplinks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Conversion from MS Access to Postgresql
Date: 2000-06-26 21:49:04
Message-ID: 3957CFD0.5228E67@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"G.L.Lim" wrote:
>
> Hi,
>
> I am curently using MS Access and would like to convert my existing Access
> database to Postgresql database (maybe into Postgresql dump file first if
> neccessary). Is there any utility or program that can do that? Please
> advise.

I have a perl program which will load the .csv files you can dump from
Access. That will only move the data, of course. I generally find it
better to write a script to build the database by hand, but I think you
can export a script from Access that will work without too much editing.

Reply if you want my perl program.

Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2000-06-26 22:00:27 Re: DateTime fields
Previous Message Karel Zak 2000-06-26 21:04:57 Re: DateTime fields