Re: Importing Data into Postgresql from MS Access

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@chapelperilous.net <bmccoy@chapelperilous.net>
To: Kevin Leclaire <kevin@virtualnav.com>
Cc: pgsql-novice@postgresql.org <pgsql-novice@postgresql.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
>
>