Re: Export data to MS Excel - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Export data to MS Excel
Date
Msg-id 325480.99793.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to Export data to MS Excel  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List pgsql-general
--- Ashish Karalkar <ashish.karalkar@info-spectrum.com> wrote:
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?

Excel has the ability to directly pull data from any system ODBC DSN configured on the windows
box.   Was is nice with this method is the ability for the users to "Refresh" the exported data
directly from excel using the build in functionality of excel.

http://pgfoundry.org/projects/psqlodbc/
http://www.sls.psi.ch/controls/help/tutorials/Excel_ODBC/index.html

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: JOIN issues (Left vs Right for sorting), and "Nested Loop" problem
Next
From: Alban Hertroys
Date:
Subject: Re: Obtaining random rows from a result set