Re: access.mdb import

Or you can install the ODBC driver, link to your postgres tables from
Access, and cut and paste (if you are more comfortable doing it that way).

David Boerwinkle

----- Original Message -----
From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: <rob(dot)yelle(at)ektron(dot)com>
Cc: Pgsql-Novice <pgsql-novice(at)postgresql(dot)org>
Sent: Wednesday, December 06, 2000 1:20 PM
Subject: Re: [NOVICE] access.mdb import

> Rob Yelle wrote:
> >
> > I have an access.mdb database that I want to import into postgres.
> > I am running postgres on a linux-redhar6.2 system.
> > Can I do this?
>
> I export to CSV and use the attached perl script. You probably will
> need to modify the perl script a little.
>
> Cheers,
> Andrew
> --
> _____________________________________________________________________
> Andrew McMillan, e-mail: Andrew(at)catalyst(dot)net(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