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!