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