* David Fetter (david@xxxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature