Re: Accessing iSeries data from OpenOffice

[Peter.Colpaert@xxxxxxxxx]

Pete,

I will give the JDBC route a try.

Thanks,

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



Pete Helgren <Pete@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/12/2006 17:12
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 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