Re: convert mdb files to pg?

On Thu, Jan 27, 2005 at 02:50:11PM -0500, Stephen Frost wrote:
> * David Fetter (david(at)fetter(dot)org) 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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!