Re: Moving data from M$ JetDB file to Postgres on Linux

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