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