Re: convert mdb files to pg? - Mailing list pgsql-general

* 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?

    Stephen