Re: export to excel format

Missed the original post, but Jakarta's POI can read/write excel from
java. Works pretty well, I'm using it on a project here.

Peter

--
Peter Mount
peter(at)retep(dot)org(dot)uk
http://www.retep.org.uk/
Tel/Fax: +44 (0) 1622 749439
Mobile: +44 (0) 7903 155887
US Fax: 1 435 304 5165
US Voice: 1 435 304 5165
IM-MSN: retep207(at)hotmail(dot)com
IM-AOL/ICQ: retepworld

On Fri, 11 Apr 2003, Jan Wieck wrote:

> 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(at)Yahoo(dot)com #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>