Re: Excel, OpenOffice and Postgres

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@postgresql.org so that your     message can get through to the mailing list cleanly