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
passthem onto the query as params in the query predicate. I found the "QueryEditor.xla" add-in very valuable in this
regardas it allows you to edit the sql query as text instead of their goofy and limited graphical editor which is often
notup to the task.
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general