CPYTOIMPF

[David Abramowitz]

Yes, but not by using CPYTOIMPF. Dave

[Guest.Visitor]

Ok, so what other means can I use to keep the column headings? I want to be able to use the converted file as an E-mail attachment and sent via the AS/400. I already a CL program that does the CPYTOIMPF and SNDDST. Thanks, Rene

[David Abramowitz]

You did not mention E-Mailings with SNDDST in your first post. If you use the Client Access Download facility, you can retain column headings. You could also specify your own headings, and transfer the data using the Excel add-in. Another method would be to use ODBC. There have been many other methods mentioned on this site. Dave

[Guest.Visitor]

What I do, quick and dirty is do the CPYTOIMPF in 2 steps. CPYTOIMPF FROMFILE(*LIBL/HEADFILE) + TOSTMF('ldrivemyflrState_Profile.csv') + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) + RCDDLM(*LF) /* PUT OUT HEADER RECORD */ CPYTOIMPF FROMFILE(QTEMP/STPROFL11) + TOSTMF('ldrivemyflrState_Profile.csv') + MBROPT(*ADD) STMFCODPAG(*PCASCII) + RCDDLM(*LF) File HEADFILE is just a flat file with "HEADING 1", "HEADING 2" , "HEADING 3"

[Guest.Visitor]

Is there a way to keep to column headings in a file when downloading from the AS/400 to Excel? thanks, Rene

[Guest.Visitor]

David, you say :"If you use the Client Access Download facility, you can retain column headings". 1.How to have headings if download to text file or others than EXCEL? 2.How to have icons in EXCEL to down/up load from/to as/400 (EXCEL was installed later than AS/400)?