Re: Moving data from M$ JetDB file to Postgres on Linux
От | Rich Shepard |
---|---|
Тема | Re: Moving data from M$ JetDB file to Postgres on Linux |
Дата | |
Msg-id | alpine.LNX.2.00.1402281627290.5076@localhost обсуждение исходный текст |
Ответ на | Re: Moving data from M$ JetDB file to Postgres on Linux (Thomas Kellerer <spam_eater@gmx.net>) |
Ответы |
Re: Moving data from M$ JetDB file to Postgres on Linux
|
Список | pgsql-general |
On Sat, 1 Mar 2014, Thomas Kellerer wrote: > It's not clear to me what exactly you are trying to do. > Or are you just trying to copy the data into the Postgres database? > If the latter you could try one of the JDBC based query tools to export > or copy the data using the UCanAccess JDBC driver for MS Access: Well, if I had any Microsoft software on a system that might work well. However, I've used nothing but F/OSS on linux since 1997. Or, are you saying that from within psql on my linux system I can access the data in the .mdb? What I want to do is extract the data from the JetDB as SQL or otherwise get it out of the proprietary format so I can store and manipulate it in postgres and analyze it with R. I'll grab the latest mdbtools and see if that works. I did not realize before that the JetDB has the same file format as Access. Rich
В списке pgsql-general по дате отправления: