Postgres Pro
Downloads
Home   >   mailing lists

Thread: access.mdb import

access.mdb import

From
"Rob Yelle"
Date:





















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?

Re: access.mdb import

From
Andrew McMillan
Date:
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@catalyst.net.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
Attachment

Re: access.mdb import

From
Date:
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@catalyst.net.nz>
To: <rob.yelle@ektron.com>
Cc: Pgsql-Novice <pgsql-novice@postgresql.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@catalyst.net.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

RE: access.mdb import

From
"Sam and Lisa Snow"
Date:
Looks like what you need is pgAdmin -->
http://www.greatbridge.org/project/pgadmin/projdisplay.php

Sam

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Rob Yelle
Sent: Wednesday, December 06, 2000 11:42 AM
To: Pgsql-Novice
Subject: [NOVICE] access.mdb import


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?

Re[2]: access.mdb import

From
Bruno Dickhoff
Date:
Hello Sam,
Friday, December 08, 2000, 5:41:44 AM, you wrote:

SaLS> Looks like what you need is pgAdmin -->
SaLS> http://www.greatbridge.org/project/pgadmin/projdisplay.php

Sorry, the url seems to be not correct, I get an error everytime I try to open
it...

--
Best regards,
 Bruno                            mailto:bruno@dickhoff.de