Re: export data to excel

akp geek wrote:
> On Tue, May 25, 2010 at 2:33 PM, John R Pierce <pierce@hogranch.com
> <mailto:pierce@hogranch.com>> 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.