Re: Accessing iSeries data from OpenOffice

I wrote a CL command named SQL2STMF which runs an SQL Select statement, passed 
as a parameter, and outputs the result set to a stream file in .TXT, .CSV, or 
.XML formats.

Can OpenOffice import .CSV files like Excel?  Send me a private email if you'd 
like me to send a *SAVF with the command to you.

Nathan.


----- Original Message ----
From: "Peter.Colpaert@xxxxxxxxx" <Peter.Colpaert@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Thursday, December 7, 2006 7:37:07 AM
Subject: Accessing iSeries data from OpenOffice

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.







 
____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com