×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
ok, one more guess:
http://jplamontre.free.fr/AS400/SQL2XLS.htm
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, May 22, 2012 7:33 AM
To: Midrange Systems Technical Discussion
Subject: RE: sql2xls
Nope, that's more of a roll your own. If I was interested in that I'd start with
http://www.scottklement.com/presentations/#RPGHSSF
I was looking for this:
SQL2XLS SQLSTMT('select iprod,idesc from iim')
TOXLS('/home/rob/ItemList.xls')
COLHDRS(*FLDNAM)
TITLE(ITEMLIST)
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Gary Thompson <gthompson@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 05/22/2012 09:30 AM
Subject: RE: sql2xls
Sent by: midrange-l-bounces@xxxxxxxxxxxx
maybe this is the link you want?
http://poi.apache.org/spreadsheet/index.html
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, May 22, 2012 7:11 AM
To: midrange-l@xxxxxxxxxxxx
Subject: sql2xls
Anyone have a working link for the download for sql2xls? The link in this
article is broken
http://www.mcpressonline.com/microsoft/techtip-excel-on-the-fly.html
Rob Berendt
midrange.com
