| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Export data to MS Excel |
| Date: | 2007-09-01 15:26:18 |
| Message-ID: | 325480.99793.qm@web31809.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2007-09-01 15:44:27 | Re: Obtaining random rows from a result set |
| Previous Message | Tom Lane | 2007-09-01 15:23:27 | Re: JOIN issues (Left vs Right for sorting), and "Nested Loop" problem |