Re: Accessing iSeries data from OpenOffice

[Pete Helgren <Pete@xxxxxxxxxx>]

I use the JDBC connection from within Open Office.  The trick is getting 
the classpath and DB URL correct but it does work.

F4 in any OO application will bring up the DB window.  Then add a DB 
(JDBC connection) and you should be up and running. Not exactly snappy 
and I haven't run queries that were in the tens of thousands of records 
but it works.

You could also open a csv in OO and it will treat it as a spreadsheet 
and start the import wizard.

Pete Helgren


Peter.Colpaert@xxxxxxxxx wrote:
> Hi group,
>
> At home I already use OpenOffice exclusively, but here at work I still 
> rely on the iSeries Data Transfer plugin for Excel if I need to download 
> massive amounts of data into a spreadsheet.
>
> For small recordsets, I use the export to excel functionality in the 
> Quantum plugin for WDSCi, but once over a certain amount of data, it will 
> crash WDSCi (memory problems).
>
> Has anybody been able to get iSeries data into an OpenOffice spreadsheet 
> directly?  Either through a data source or an OpenOffice database 
> (probably using JDBC)?
>
> Thanks in advance,
>
> Peter Colpaert
> Application Developer
> PLI - IT - Kontich, Belgium
> -----
> Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> -----
>