RE: Accessing iSeries data from OpenOffice

Hi Peter,

        What's wrong with cpytoimpf to a .csv file and open with open
office?  Have I missed a salient point?  I don't particularly like the
cpyto/frm stuff and use my own rpg for production stuff but for one-offs I
often use them...

Regards,
Rick DuVall
Systems Manager
Dealer's Auto Auction of Okc
1028 S. Portland
Oklahoma City, OK 73108
(405) 947-2886
rick@xxxxxxxxxx 
http://www.nothingisreal.com/dfki/no-word

 

On Behalf Of Peter.Colpaert@xxxxxxxxx
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.
-----