RE: Accessing iSeries data from OpenOffice

I have used ODBC and Open Office 2.x Database tool for about a year now.  It
works fine.  I never tried the Spreadsheet app with the ODBC connection but
I don't see why it won't work.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Peter.Colpaert@xxxxxxxxx
Sent: Friday, December 08, 2006 1:49 AM
To: Midrange Systems Technical Discussion
Subject: Re: Accessing iSeries data from OpenOffice

Nathan,

thanks for the offer, but I wrote my own CPYPF2XLS utility, wich converts 
any PF to an XLS in the IFS.  It takes a long time for large files, 
though.

However, I could always use Excel at work.

I was just wondering whether it could be done (it = accessing iSeries data 
from OO)

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



Nathan Andelin <nandelin@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/12/2006 16:19
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
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.