On Thu, Jan 27, 2005 at 02:50:11PM -0500, Stephen Frost wrote: > * 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? Hrm. Well, given the givens, I'd say calling the stuff up on a Windows machine is probably your easiest method. And possibly exporting to something that's easier to read on *n*x, like Excel or CSV. 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
