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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!