Re: getting mdb(microsoft acess) file in postgresql - Mailing list pgsql-novice

From Glenn Davy
Subject Re: getting mdb(microsoft acess) file in postgresql
Date
Msg-id 1153832817.13887.10.camel@localhost.localdomain
Whole thread Raw
In response to getting mdb(microsoft acess) file in postgresql  ("nitin quick" <quick.nitin@gmail.com>)
List pgsql-novice
On Tue, 2006-07-25 at 16:51 +0530, nitin quick wrote:
> How can i read or import a mdb database file into postgresql?
sor
its years since Ive done it, so there might be fine detail to sort along
the way. but you can...

* Connect to postgres with odbc and link tables into mdb file then make
'append' queries in access
*  Export to CSV from access then use the postgresql copy command to
import the csv data
* if your on *nix then you might be able to use  kexi to do a query that
copies from the mdb file to postgres as I believe it handles both. There
are also other similar tools in the gnome stable I believe

>regards
> quickNitin

pgsql-novice by date:

Previous
From: "nitin quick"
Date:
Subject: getting mdb(microsoft acess) file in postgresql
Next
From: Richard Broersma Jr
Date:
Subject: Re: getting mdb(microsoft acess) file in postgresql