Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

Next:From: Rich ShepardDate: 2009-11-11 20:17:40
Subject: Re: Converting .mdb Files
Previous:From: Roderick A. AndersonDate: 2009-11-11 19:31:10
Subject: Re: Converting .mdb Files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group