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
>
