Thread

1. access.mdb import

   Rob Yelle <rob.yelle@ektron.com> — 2000-12-06T18:42:29Z

   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   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?
   
   
   
   
   
   
   
   
   
   
   
   
   
   

2. Re: access.mdb import

   Andrew McMillan <andrew@catalyst.net.nz> — 2000-12-06T19:20:33Z

   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

3. Re: access.mdb import

   davidb@vectormath.com — 2000-12-07T15:27:49Z

   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
   
   
   

4. RE: access.mdb import

   Sam and Lisa Snow <2snows@mailandnews.com> — 2000-12-08T04:41:44Z

   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?
   
   
   

5. Re[2]: access.mdb import

   Bruno Dickhoff <bruno@dickhoff.de> — 2000-12-08T16:30:02Z

   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