RE: Access 97 Database and Postgres

From: <bmccoy(at)chapelperilous(dot)net>
To: Wilkinson Charlie E <Charlie(dot)E(dot)Wilkinson(at)irs(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: Access 97 Database and Postgres
Date: 2000-07-26 18:20:42
Message-ID: Pine.LNX.4.10.10007261409590.16149-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 26 Jul 2000, Wilkinson Charlie E wrote:

> Mmm?? Now you've really got my ear. You're saying I could hack up
> something in Perl on the Linux box to snarf data out of the Access
> database on the Windoze box via ODBC? (I just assumed that the
> Windoze ODBC stuff would be client-only.) I've already done some DBI
> stuff with Postgres, so I'm not completely out in the dark here.

Check out www.unixodbc.com -- you'll have to set up an ODBC-ODBC bridge to
connect to Access, but it can be done. There's also an ODBC module for
Perl on the Windows side, but then you're still stuck with using ODBC to
connect back to Postgres. But it's Perl -- it's much faster, smarter and
cooler than having do it inside of Access or with Visual Basic!

Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
Drop that pickle!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2000-07-26 18:35:35 PostgreSQL + Microsoft Access FAQ Draft Announcement
Previous Message Wilkinson Charlie E 2000-07-26 17:59:33 RE: Access 97 Database and Postgres