Re: query to excel

["Peter Dow" <pcdow@xxxxxxxxx>]

Your data is not being converted from EBCDIC to ASCII, because your transfer
request doesn't say to do it. If you're using Client Access, find the
transfer request (.tto file) and look at the properties page. Check the box
labelled "Convert CCSID 65535". Then try the transfer again.

You can access the properties page from Excel only when you're creating a
new transfer request as far as I can tell.

hth
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: <Imaginor@aol.com>
> I have downloaded an output file, created from a query, to an excel
spreadsheet with the following problem:
>
> Using the digits operation in query, I mapped a six byte numeric field
(that stores a date) and a two byte numeric field (that stores a
century)into one eight byte alpha date result. When i transferred to excel,
the date is reading as "F1 F9 F9 F9...zone format. I need to sort this field
for various reporting requests. How can i solve this problem either through
the 400 query function or within excel.  Thank you.

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


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

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