akp geek wrote:
On Tue, May 25, 2010 at 2:33 PM, John R Pierce <pierce@xxxxxxxxxxxx <mailto:pierce@xxxxxxxxxxxx>> wrote: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.I tried this option, the error that I was getting can not use "crypt". The I have used the open office as Peter mentioned and that worked for me. I will try the other options mentioned also
not sure what "crypt" has to do with anything here. you would need a postgres odbc or adodb or whatever driver that windows and excel can use to access postgres directly.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
