Thread: OSX, ODBC and Office 2004

OSX, ODBC and Office 2004

From
Konstantinos Agouros
Date:
Hi,

does this work in any way (PG 7.4.7 and OSX 10.3), so I can access postgres
as data source from say excel?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres

Re: OSX, ODBC and Office 2004

From
John DeSoi
Date:
On Mar 22, 2005, at 12:55 PM, Konstantinos Agouros wrote:

> does this work in any way (PG 7.4.7 and OSX 10.3), so I can access
> postgres
> as data source from say excel?

I don't have any recent versions of Excel, but PostgreSQL should work
with ODBC on the Mac. You'll find the ODBC administrator application in
/Applications/Utilities. You'll need to compile the psql odbc library
from here:

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

Here are a couple of articles on setting up ODBC on the Mac:

http://www.macdevcenter.com/pub/a/mac/2003/06/20/odbc.html
http://www.macdevcenter.com/pub/a/mac/2003/07/25/odbc.html



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: OSX, ODBC and Office 2004

From
tony
Date:
Le mardi 22 mars 2005 à 17:55 +0000, Konstantinos Agouros a écrit :

> does this work in any way (PG 7.4.7 and OSX 10.3), so I can access postgres
> as data source from say excel?

I use OpenOffice.org and JDBC

Tony