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.klaver@aklaver.com