| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Moving data from M$ JetDB file to Postgres on Linux |
| Date: | 2014-03-01 00:33:23 |
| Message-ID: | alpine.LNX.2.00.1402281627290.5076@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2014-03-01 00:34:55 | Re: Moving data from M$ JetDB file to Postgres on Linux |
| Previous Message | Adrian Klaver | 2014-03-01 00:19:36 | Re: Moving data from M$ JetDB file to Postgres on Linux |