EMS-Hitech ( http://www.sqlmanager.net ) has a product called PgDataPump
- I have used it to import a number of Access Databases to Postgres, it
is fast, quick to set up, and will even import indexes and
relationships. They also have an import utility for fine grained control
over the import of data sets (usually particular tables). I have used it
with Postgres 8.0 b2, b5, rc1 and final as well as worth 7.4.2.
You can also use it across a network (Import Access DB on Winbox1 to PG
DB on Linbox 2)
Cheers
Johan Wehtje
David Fetter wrote:
>On Thu, Jan 27, 2005 at 02:50:11PM -0500, Stephen Frost wrote:
>
>
>>* David Fetter (david@fetter.org) wrote:
>>
>>
>>>On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote:
>>>
>>>
>>>>Is there a way to import mdb files from Access into pg?
>>>>
>>>>I found a web page for mdbtools but I can't get it to compile.
>>>>
>>>>
>>>Here are a couple of ways to approach the problem:
>>>
>>>1. Use DBI and connect both to your mdb data source and to your
>>>PostgreSQL one. Loop through SELECT on the mdb and do INSERTs on
>>>PostgreSQL.
>>>
>>>2. DBI-Link, which is probably overkill for this.
>>>
>>>http://pgfoundry.org/projects/dbi-link/
>>>
>>>Of course, there are other ways, but those are the two that came
>>>to mind :)
>>>
>>>
>>Both of these methods require a Windows machine for the perl to be
>>running on, right?
>>
>>
>
>Hrm. Well, given the givens, I'd say calling the stuff up on a
>Windows machine is probably your easiest method. And possibly
>exporting to something that's easier to read on *n*x, like Excel or
>CSV.
>
>Cheers,
>D
>
>