Re: Downloading a file created by Query via Excel

Easy.

When you are editing your data transfer, click on File, Properties, 
Conversions tab, turn on Convert CCSID 65535.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Joe Lewis <joelewis@xxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/29/2004 03:59 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Downloading a file created by Query via Excel






Here is something that has been troubling me for a long time.  I have 
been using Query to create information and then download to a PC via 
excel for a long time now.  But every time I create a field using 
"Define result fields," when I download that field, it always comes 
across in hex from.  All the data that was directly taking form the 
source file(s) looks great, the field created by use "Define result 
fields" option are messed up. 

Example:  Data in the field "SomeDat" is a char length of 6 (MMDDYY)- 
042904.   Our example query brings "SomeDat" over as is, we get 042904 
in excel.  But if want to format the date so it make sense (YYMMDD) for 
sorts, one should be able to do some SUBSTRs and ||s  and get something 
like 04/04/29.  Viewing the file using DSPPFM, data looks great.  But, 
after downloading via excel we end up with F0F461F0F461F2F9.  I have 
been dealing with this for years.  Anyone have any ideas one this.  FYI 
- get the same problem when downloading the file straight into a CVS 
format. 

Thanks for any help,
Joe Lewis


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.