Re: [GENERAL] export data to excel

2010-05-25 Thread John R Pierce
akp geek wrote: On Tue, May 25, 2010 at 2:33 PM, John R Pierce > 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,

Re: [GENERAL] export data to excel

2010-05-25 Thread akp geek
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 thanks for the support Regards On Tue, May 25, 2010 at 2:33 PM, John R Pierce wrote: > akp geek wrote:

Re: [GENERAL] export data to excel

2010-05-25 Thread Dave Coventry
There is also the Java POI classes (Poor Obfuscation Implementation) for importing and exporting doc and docx, HSSF (Horrible SpreadSheet Format) for exporting and importing xls and xlsx, http://poi.apache.org/ There are also implementations for Outlook, Powerpoint and Visio. Java can be integrat

Re: [GENERAL] export data to excel

2010-05-25 Thread Gauthier, Dave
e 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 t

Re: [GENERAL] export data to excel

2010-05-25 Thread Peter Geoghegan
> 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 > Regards Why not just save to the CSV file to XLS from within Excel? XLS, and to a le

Re: [GENERAL] export data to excel

2010-05-25 Thread John R Pierce
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 q

[GENERAL] export data to excel

2010-05-25 Thread akp geek
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 Regards