From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: export data to excel |
Date: | 2010-05-25 21:10:04 |
Message-ID: | 4BFC3CAC.5060509@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
akp geek wrote:
> On Tue, May 25, 2010 at 2:33 PM, John R Pierce <pierce(at)hogranch(dot)com
> <mailto:pierce(at)hogranch(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Goran Hasse | 2010-05-25 21:21:30 | Re: How to fetch values at regular hours? |
Previous Message | Tim Landscheidt | 2010-05-25 21:06:57 | Re: How to fetch values at regular hours? |