Re: convert mdb files to pg?

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

Remember to vote!