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