Re: Excel, OpenOffice and Postgres

From: Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
To: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
Cc: Bob Powell <Bob(at)hotchkiss(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Excel, OpenOffice and Postgres
Date: 2003-12-17 18:30:57
Message-ID: 3FE0A0E1.6070302@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello javier garcia,

>Hello Bob;
>Some time ago I were using Postrges along with Excel via Microsoft Query and
>ODBC. I just remember that there was a problem when trying to see views but
>it worked with single tables. Perhaps you can experiment with that.
>
>
This problem can be over come by unticking the updateable cursurs in
pgsqlODBC config menu
Regards Vishal Kashyap

>Javier
>
>El Mié 17 Dic 2003 17:01, Bob Powell escribió:
>
>
>>Hello everyone:
>>
>>Can anyone tell me if it is possible to connect excel or openoffice via
>>odbc directly to a postgres backend database.
>>
>>Also, if that is possible does either OpenOffice or Excel support SQL
>>queries to said database?
>>
>>Bob Powell
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-17 18:37:55 Re: Firebird and PostgreSQL at the DB Corral.
Previous Message Christopher Murtagh 2003-12-17 18:20:50 Permissions issue?