Thread: 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
>
>

Hey Kevin,
    If you have an ODBC link it is super easy to move tables to postgres.
1)  In MS Access, right-click on your table and select SAVE AS/EXPORT
2)  Select 'ODBC Connection' in the Export Format drop-down list
      at the bottom of the SAVE AS screen.  ODBC is dead last in the list.
3)  You are then prompted to select the ODBC connection you want to save to.
4)  Here is the beauty of it-- Your table schema _and_ your data is sent
     to your postgres system.  No indices are created, but all fields are.
Have fun,
    Dave

On Thu, 12 Oct 2000 17:05:10 -0400, you wrote:
> Does anyone know of a utility which can easily convert MS Access tables into
> Postgres?
>
> 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.
>
> Thanks for your help!
> Kevin
>
>

Another way you may be able to move data is to use the JDBC-ODBC bridge to:
- use java.sql.ResultSetMetaData to define the new PostgreSQL table,
- extract the data from Access and load into PostgreSQL using SQL.

FWIW, Gord Tomlin

-----Original Message-----
From: pgsql-novice-owner@hub.org [mailto:pgsql-novice-owner@hub.org] On
Behalf Of David Huttleston Jr
Sent: Thursday, October 12, 2000 17:54
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Importing Data into Postgresql from MS Access


Hey Kevin,
    If you have an ODBC link it is super easy to move tables to postgres.
1)  In MS Access, right-click on your table and select SAVE AS/EXPORT
2)  Select 'ODBC Connection' in the Export Format drop-down list
      at the bottom of the SAVE AS screen.  ODBC is dead last in the list.
3)  You are then prompted to select the ODBC connection you want to save to.
4)  Here is the beauty of it-- Your table schema _and_ your data is sent
     to your postgres system.  No indices are created, but all fields are.
Have fun,
    Dave

On Thu, 12 Oct 2000 17:05:10 -0400, you wrote:
> Does anyone know of a utility which can easily convert MS Access tables
into
> Postgres?
>
> 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.
>
> Thanks for your help!
> Kevin
>
>