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

Rich Shepard wrote on 01.03.2014 00:21:
> I just downloaded two scientific data files from a federal agency's Web
> site. Both are in M$ JetDB format. I run only linux and keep all my
> scientific dat in postgres.
>
> My Web search did not turn up anything useful; the closest was a thread
> from this mail list in 2000 on how to send a postgres query through odbc to
> an Access database.
>
> Is there a filter I can use to get the data from these files?
>

It's not clear to me what exactly you are trying to do.

Are you trying to query the Access database from within Postgres?

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:

http://sourceforge.net/projects/ucanaccess/

UCanAccess works quite well with the tool I am maintaining as far as I can tell.
The WbCopy command or the DbExplorer should be able to copy the data over to Postgres.

http://www.sql-workbench.net/
http://www.sql-workbench.net/manual/command-copy.html
http://www.sql-workbench.net/manual/data-pumper.html

Another alternative would be to export the Access database to flat files and import those into Postgres.

Thomas