Re: getting mdb(microsoft acess) file in postgresql

Поиск
Список
Период
Сортировка
От Glenn Davy
Тема Re: getting mdb(microsoft acess) file in postgresql
Дата
Msg-id 1153832817.13887.10.camel@localhost.localdomain
обсуждение исходный текст
Ответ на getting mdb(microsoft acess) file in postgresql  ("nitin quick" <quick.nitin@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "nitin quick"
Дата:
Сообщение: getting mdb(microsoft acess) file in postgresql
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: getting mdb(microsoft acess) file in postgresql