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

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(dot)klaver(at)aklaver(dot)com