RE: Size of .XLS files and auto sending rumba transfer

Don't know the max size of records in .XLS but if you want to do it in a CL program, you might consider a product by Millennium Information Systems called "Convert to PC File".  It allows any database file to be converted to a true Excel file.  Prior to this, I had used the CPYTOIMPF command by IBM but this only allows creating a delimited file and has limitations and some problems (doesn't allow headings, doesn't recognize embedded commas or double quotes, etc.).  The utility is inexpensive also (under $500 I think).  If you're interested in this, send an e-mail to mailto:markdonovan@millenniumis.com.

Dave
p.s.  I'm not associated with MillenniumIS - I just use and like their product.

-----Original Message-----
From: Donald Cook [mailto:dcook@hubgroup.com]
Sent: Friday, February 04, 2000 11:52 AM
To: MIDRANGE-L@midrange.com
Subject: Size of .XLS files and auto sending rumba transfer

Does anyone know the max size of records in the .XLS format. Also is there a way
that I can create  a CL program  to send a file from the AS/400 to the PC
instead of doing it manual from the rumba transfer.

Thanks in advance

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---