Re: Converting .mdb Files

From: "Roderick A(dot) Anderson" <raanders(at)cyber-office(dot)net>
To: Postgresql PDX_Users <pdxpug(at)postgresql(dot)org>
Subject: Re: Converting .mdb Files
Date: 2009-11-11 19:59:42
Message-ID: 4AFB17AE.3000408@cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

Roderick A. Anderson wrote:
> Rich Shepard wrote:
>> I have a 12.1 .mdb file (M$ Access) that I want to convert for use in
>> postgres. mdbtools-0.5 segfaults when I try to run mdb-schema and
>> mdb-export. mdbtools-0.6pre1 fails to compile. I don't know that this
>> project is maintained any longer.
>>
>> Has anyone here found a linux-hosted tool to convert these Access
>> files to
>> something useful like postgres?
>
> A quick search using Google seems to indicate the mdb driver is part of
> OpenOffice.Org.
>
> I must have un-installed it, for some unknown reason, so it will be a
> bit before I can confirm this.

From what I can deduce the drivers are only available in the Windows
version of OOo.

My mdb-tools (0.5-1 on a CentOS 5.4 system) seems to be working OK. I
have a 5 GByte mdb that looks to be from the USFS -- Road features from
2006. I was able to -export, -schema, and -tables it fine.

It you want/can share your file I'll convert for you.

Rod
--
>
>
> \\||/
> Rod

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2009-11-11 20:17:40 Re: Converting .mdb Files
Previous Message Roderick A. Anderson 2009-11-11 19:31:10 Re: Converting .mdb Files