Re: convert mdb files to pg?

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 :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!