RE: Copy AS/400 file to an Excel file

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

What version are you on?  You could do a cpytoimpf using the stream file
parameter instead of the database file parameter and you'd have your comma
demilited file in one command.  That should be easy enuff.

I think you need V4R2 for this.

Bradley V. Stone
Taylor Corporation - OASIS Programmer/Analyst   
bvstone@taylorcorp.com


> -----Original Message-----
> From: Leland, David [SMTP:dleland@Harter.com]
> Sent: Wednesday, May 26, 1999 3:00 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      Copy AS/400 file to an Excel file
> 
> I'm looking for a program to create an Excel file from an AS/400
> database file, and to have the Excel file reside on the IFS - no PC
> involved, initiated from the AS/400, and without human intervention.  I
> believe that Sequel can do this but I've never been a big Sequel fan and
> I don't want to pay that much (I'm looking for something for $500 or
> less.).  I'd like more of a standalone utility that I could easily
> incorporate into our nightly batch processing.  The people at Millennium
> Information Systems (www.millenniumis.com) were working on just such a
> product but they've apparently gone out of business (their phone's been
> disconnected and they don't respond to e-mails).
> 
> Anyone know of such a product, or have anything in their bag of goodies
> they'd be willing to share?
> 
> Thanks,
> Dave
> +---
> | 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
> +---
+---
| 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
+---