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