Skip site navigation (1) Skip section navigation (2)

Re: Importing Data into Postgresql from MS Access

From: <davidb(at)vectormath(dot)com>
To: <bmccoy(at)chapelperilous(dot)net>, "Kevin Leclaire" <kevin(at)virtualnav(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Importing Data into Postgresql from MS Access
Date: 2000-10-12 21:32:16
Message-ID: 002601c03493$e82e28f0$0602010a@bullwinkle.VECTORMATH (view raw or flat)
Thread:
Lists: pgsql-novice
For Access97 we used something we found at:
http://www.sevainc.com/Access/index.html
and it worked well.

David Boerwinkle
-----Original Message-----
From: bmccoy(at)chapelperilous(dot)net <bmccoy(at)chapelperilous(dot)net>
To: Kevin Leclaire <kevin(at)virtualnav(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)org>
Date: Thursday, October 12, 2000 4:13 PM
Subject: Re: [NOVICE] Importing Data into Postgresql from MS Access


>On Thu, 12 Oct 2000, Kevin Leclaire wrote:
>
>> Does anyone know of a utility which can easily convert MS Access tables
into
>> Postgres?
>
>pgAdmin has an Access migration utility.  It works through the Pg ODBC
>driver.  See http://www.pgadmin.freeserve.co.uk/
>
>> Alternatively, I can export to any format that MSAccess supports (e.g.
>> comma-delimited text), but would like to know if there are any import
>> utilities which will simplify the import process into postgres so I don't
>> have to write a script for 100 fields X thousands of records.
>
>If you export into some kind of delimited format, you can easily use the
>COPY or /copy commands with psql.
>
>Brett W. McCoy
>                                              http://www.chapelperilous.net
>---------------------------------------------------------------------------
>The full potentialities of human fury cannot be reached until a friend
>of both parties tactfully interferes.
> -- G.K. Chesterton
>
>


pgsql-novice by date

Next:From: David Huttleston JrDate: 2000-10-12 21:53:39
Subject: Re: Importing Data into Postgresql from MS Access
Previous:From: Jean-Christophe BoggioDate: 2000-10-12 21:13:20
Subject: Re: Importing Data into Postgresql from MS Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group