Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/28/2014 04:10 PM, Thomas Kellerer wrote:
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/

That is one I missed. Thanks for the heads up.




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux