RE: sql2xls

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