Re: Excel, OpenOffice and Postgres

Dear Bob Powell ,

>Can anyone tell me if it is possible to connect excel or openoffice via
>odbc directly to a postgres backend database.
>
>
Yes you can do this .
What you need is :
1. pgsqlODBC download it from www.postgresql.org for Windows
2.  Unix ODBC for OpenOffice in xNIX.
For windows :
1. Make an ODBC connection to your database  with required password /
host name  as
    Click on
    >START>CONTROL PANEL >  PERFORMANCE AND MAINTAINCE > ADMIN TOOLS > ODBC
Now with this ODBC connection you can View tables on OpenOffice and M$ Excel

>
>Also, if that is possible does either OpenOffice or Excel support SQL
>queries to said database?
>
>
Yes and more OpenOffice 1.1 alows forms for data input and report generation
Note :
 Form part I have not tested but I have seen it



Tell me If this helps
Regards,
Vishal Kashyap