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@retep.org.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:
1435 304 5165   IM-MSN: retep207@hotmail.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@Yahoo.com #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>