Re: export data to excel

csv can easily be swallowed by Excel as a data source.

I like the ODBC based query suggestion better. I've configured Excel to accept user inputs via text input widgets and pass them onto the query as params in the query predicate. I found the "QueryEditor.xla" add-in very valuable in this regard as it allows you to edit the sql query as text instead of their goofy and limited graphical editor which is often not up to the task.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Tuesday, May 25, 2010 2:33 PM
To: akp geek
Cc: pgsql-general
Subject: Re: [GENERAL] export data to excel

akp geek wrote:
> Deal All -
>
> I would like to know if there is any plug in available
> to export the result to excel from pgadmin. if I do that now, all the
> data gets exported as csv . Appreciate your help

configure excel to use the postgres database as an ODBC 'data source'
and query it directly from your spreadsheet.