transfer data to xls format

140 pts.
Tags:
AS/400
Could you suggest me how to convert data from as/400 system file (physical file) to xls.doc file.

FYI i am using extra software for as/400

please tell me a procedure

 

Answer Wiki

Thanks. We'll let you know when a new response is added.

<a href=”http://lmgtfy.com/?q=as400+file+to+xls”>Google is your friend!</a>

=========================================================

First step should be to ensure that your system is properly configured for CCSID conversions. If your QCCSID system value is anything but 65535, you are probably okay. However, if it is 65535, then you should review the possible implications of changing away from 65535 to an appropriate value. (The 65535 value more or less tells your system to avoid doing CCSID conversions when transferring data to or from other systems. It’s something like trying to do all FTP transfers in BINARY.)

Next, if you need actual .XLS files, then you will need to create or obtain programming that is capable of writing in Excel format. Excel is a Windows/Microsoft product, not an IBM product.

Finally, if you only need to do transfers in a <i>compaible</i> format, you can use the CPYTOIMPF command. An example of a <i>compatible</i> format would be a .CSV file. Although “.CSV” generally means “Comma-Separated Values”, other separator characters can often be used, e.g., ‘tab’ characters. When creating files for windows, you usually want CR and LF (carriage-return and line-feed) characters to mark end-of-line. Unix usually wants only LF characters. If you create the output streamfile with the CPYTOIMPF command, you can usually use a streamfile code page of *PCASCII.

The streamfile would be in a directory in the /root or possibly the /QNTC file system. (It could potentially even be a NFS mount from a Linux/Unix system, I suppose.) It can be in a directory that is designated as a share for Windows networking or it might be written directly to a Windows (or Linux) system on your network.

That’s a very short introduction. Add comments in the ‘Discussion’ area below if details are needed.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following