| From: | Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in> |
|---|---|
| To: | Bob Powell <Bob(at)hotchkiss(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Excel, OpenOffice and Postgres |
| Date: | 2003-12-17 17:50:01 |
| Message-ID: | 3FE09749.1060107@sancharnet.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-17 18:17:33 | Re: Reload bytea [was Re: Picture with Postgres and Delphi] |
| Previous Message | Bernd Helmle | 2003-12-17 17:39:07 | Re: copy command problem |