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

RE: Importing Data into Postgresql from MS Access

From: gordt(at)actionsoftware(dot)com (Gord Tomlin)
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Importing Data into Postgresql from MS Access
Date: 2000-10-13 16:39:29
Message-ID: 003101c03534$287e20e0$041964c6@MZ04 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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(at)hub(dot)org [mailto:pgsql-novice-owner(at)hub(dot)org] On
Behalf Of David Huttleston Jr
Sent: Thursday, October 12, 2000 17:54
To: pgsql-novice(at)postgresql(dot)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,

On Thu, 12 Oct 2000 17:05:10 -0400, you wrote:
> Does anyone know of a utility which can easily convert MS Access tables
> 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

pgsql-novice by date

Next:From: Thu HuynhDate: 2000-10-14 04:15:11
Subject: Please HELP: insert row ...
Previous:From: Patrick CoulombeDate: 2000-10-13 14:57:53
Subject: RE: starting postmaster problems

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