Thread: convert mdb files to pg?

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@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

* 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?

    Stephen

Rick Schumeyer wrote:

> -->
>
> Is there a way to import mdb files from Access into pg?
>
I would use ODBC to create linked tables from Pg and copy from the unlinked
mdb tables.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.
PostgreSQL Support

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

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!

EMS-Hitech ( http://www.sqlmanager.net ) has a product called PgDataPump
- I have used it to import a number of Access Databases to Postgres, it
is fast, quick to set up, and will even import indexes  and
relationships. They also have an import utility for fine grained control
over the import of data sets (usually particular tables). I have used it
with Postgres 8.0 b2, b5, rc1 and final as well as worth 7.4.2.
You can also use it across a network (Import Access DB on Winbox1 to PG
DB on Linbox 2)
Cheers
Johan Wehtje

David Fetter wrote:

>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
>
>

* Joshua D. Drake (jd@commandprompt.com) wrote:
> Rick Schumeyer wrote:
> >Is there a way to import mdb files from Access into pg?
> >
> I would use ODBC to create linked tables from Pg and copy from the unlinked
> mdb tables.

I've tried doing thing and discovered that for large tables it can be
quite slow... (3 hours for a couple million rows), don't suppose you
have some way to speed it up?

    Stephen

From: Rick Schumeyer

To: 'PgSql General'

Sent: Thursday, January 27, 2005 4:14 PM

Subject: [GENERAL] convert mdb files to pg?

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.

 

You can use DBTools Manager (http://www.dbtools.com.br). Besides the fact it can manage PostgreSQL, MySQL, SQLite, Interbase, Firebird and Xbase Tables it can also import and export data to and from MSAccess, MSExcel, Text Files, ODBC, Paradox, Clipper, Dbase and FoxPro.

It's for Windows but it doesn't matter were the database server is located.

Best Regards,

Crercio O. Silva

Am Thu, 27 Jan 2005 14:14:32 -0500 hat Rick Schumeyer
<rschumeyer@ieee.org> geschrieben:

> 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.

Have a look at Access2PgConverter here
http://www.talon.nl/eng/site/start/projects/main.html

Sounds promising. But I've never used it though.

--manfred

--
http://glassdoc.org
http://glassdoc.de