|
I'd be really interested to know if there is an easy way to do this too. I don't know if you have Sequel but when you output to an Excel file on QDLS through a Sequel query you get the column description in the headings field but the Excel -> AS400 always returns the field name in the column heading which doesn't always mean a lot to users! Jenny M -----Original Message----- From: Cynthia Kovarik [mailto:ckovarik@bellsouth.net] Sent: 07 August 2002 21:08 To: midrange-l@midrange.com Subject: Re: Column Headings with CAE file transfer Thanks Adam ... but the column headings it includes is the field name ... I am looking for description of field name. ----- Original Message ----- From: "Adam Lang" <aalang@rutgersinsurance.com> To: <midrange-l@midrange.com> Sent: Wednesday, August 07, 2002 3:46 PM Subject: Re: Column Headings with CAE file transfer > When you choose file type, click on the DETAILS button. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > http://www.rutgersinsurance.com > ----- Original Message ----- > From: "Cynthia Kovarik" <ckovarik@bellsouth.net> > To: <midrange-l@midrange.com> > Sent: Wednesday, August 07, 2002 3:38 PM > Subject: Column Headings with CAE file transfer > > > > This is a multi-part message in MIME format. > > -- > > [ Picked text/plain from multipart/alternative ] > > Does anyone know of a way to retain column headings when transfering file > information from AS/400 to PC/Excel? I can get field names included if I > select DIF format but have not found way to retain column headings. Thank > you! > > > > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.