I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks if anything had changed that might account for this but the answer is always "no". Since this is affecting BOTH my office PC and my laptop simultaneously, I have to believe that this has something to do with the AS400 rather than the individual Client Access installations but I am not sure. I have tried both existing queries and output files and Excel files as well as created brand-new ones. I have Googled this problem and searched the IBM support site for hours and, although I have found some references to this issue, I haven't found a satisfactory solution. A colleague has had this problem for quite some time and no one has ever been able to fix it for him. But he and I work on completely separate queries and spreadsheets. I have tried the transfers both with and without the "Convert CCSID 65535" box checked in the Data Transfer program and while that does indeed translate from hex into English, every record is in a huge single-column text string. I tried the Excel "text-to-columns" function but in some of my bigger files, the precision required to parse these records is just too much for this manual process. I have some very large projects to complete and I really need to get these Excel files into a usable condition quickly. Any help would be appreciated. Thanks.
June 2, 2011 11:22 PM
September 13, 2011 3:21 AM