RE: Copy AS/400 file to an Excel file

["Leland, David" <dleland@xxxxxxxxxx>]

To all who responded to my question about copying an AS/400 database
file to an Excel file, I'm sorry I wasn't more clear.  I realize there
are a number of AS/400 solutions for copying to a text or delmited type
file.  What I'm looking for is a TRUE Excel file (BIFF4 or BIFF5
format), the type that Client Access download function can create.

I already use the CPYTOIMPF command but am not at all happy with it.  It
doesn't give any control over formatting.  And, it you happen to have
commas or double quotes in the data which you're copying (such as an
item description), CPYTOIMPF doesn't handle them correctly.

Dave

> ----------
> From:         Ken Slaugh[SMTP:ken.slaugh@cm-inc.com]
> Reply To:     MIDRANGE-L@midrange.com
> Sent:         Wednesday, May 26, 1999 6:29 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Copy AS/400 file to an Excel file
> 
> Most of the time I port to Excel simply by creating a Tab (hex 05)
> delimited file. Simply concat your field values in a resulting
> alphanumeric field and output the field to a PF. Then run CPYTOPCD or
> CPYTOSTMF to convert to ASCII. The file suffix is simply .txt
> 
> When Excel opens this file it will see the tabs and assume them to be
> separators. Click on the Finish button to complete the import wizard
> and
> your done.
> 
> Ken Slaugh
> Senior Programmer/System Analyst
> AS/400 Professional Network Administrator/MSE
> Specialist - Client Access/400
> Chouinard & Myhre, Inc.
> 
> > -----Original Message-----
> > From:       Leland, David [SMTP:dleland@Harter.com]
> > Sent:       Wednesday, May 26, 1999 1: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
> +---
> 
+---
| 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
+---