By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,373 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,373 IT Pros & Developers. It's quick & easy.

Excel, OpenOffice and Postgres

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.

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

Nov 12 '05 #2

P: n/a
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 onSTART>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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #3

P: n/a
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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #4

P: n/a

Try this link to OpenOffice and its postgres-sdbc-driver.

http://dba.openoffice.org/drivers/postgresql/

I have Installed OO on RedHat and tested that I can connect postgres -
which it does without any dramas, but I havent done much more than that.
So I am not sure as to what the limit is on the complexity of the
queryies asked of it can be.

It doesnt connect via either odbc or jdbc, and currently it is in alpha
state, which might not be what you are after. But it could be worth a
look at.

Cheers
Matt


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #5

P: n/a
Am Donnerstag, 18. Dezember 2003 00:15 schrieb Matthew:
Try this link to OpenOffice and its postgres-sdbc-driver.

http://dba.openoffice.org/drivers/postgresql/

I have Installed OO on RedHat and tested that I can connect
postgres - which it does without any dramas, but I havent done much
more than that. So I am not sure as to what the limit is on the
complexity of the queryies asked of it can be.

It doesnt connect via either odbc or jdbc, and currently it is in
alpha state, which might not be what you are after. But it could
be worth a look at.


Just to avoid a misunderstanding: You _can_ connect OpenOffice via
odbc to postgresql without any problems. you dont need a special
postgresql driver as long as you only need odbc features. It just
works!

kind regards,
janning

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.