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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
