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-ow...@postgresql.org [mailto:pgsql-general-ow...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
