Re: export to excel format - Mailing list pgsql-interfaces

From Jan Wieck
Subject Re: export to excel format
Date
Msg-id 3E96BBFF.EA28AE13@Yahoo.com
Whole thread Raw
In response to export to excel format  (Faizol Halim <faizol_h@yahoo.com>)
Responses Re: export to excel format
List pgsql-interfaces
Faizol Halim wrote:
> 
> hi all,
>  first of all, I'm sorry if this is not the right
> place to ask (if so, where should I direct the
> question to?)
>  my question:
>  is there anyway that I could export some of my tables
> to an excel format..? any module or pointers on how
> this could be done..?

Maybe, but what about "importing" the data directly?

Get the PostgreSQL ODBC driver
   http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

and install it on your Windows box. Add the ODBC support functions on
the database side. Make sure the Windows system has access to the
database (pg_hba.conf, username/password). Create a DSN and access the
database directly from Excel.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-interfaces by date:

Previous
From: Faizol Halim
Date:
Subject: export to excel format
Next
From: Peter Mount
Date:
Subject: Re: export to excel format