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@xxxxxxxxxx http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
