Home > IT Answers > Development > uploading a excel file to ifs file on as400
Lnspgm
15 pts.
 uploading a excel file to ifs file on as400
Development, Help Desk, Tech support
Is there a way to upload a excel spreadsheet up to qdls as a ifs file?

Software/Hardware used:
ASKED: May 13, 2005  12:22 PM
UPDATED: August 18, 2010  9:40 AM
RELATED QUESTIONS
Answer Wiki:
Map a network drive to QDLS and cut/paste the .xls It's now in the QDLS file system of the IFS.
Last Wiki Answer Submitted:  May 17, 2005  6:50 am  by  PaulThomas   0 pts.
All Answer Wiki Contributors:  PaulThomas   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can also use CPYTOIMPF. That will even put delimeters and Carriage Returns and Line Feeds into the data. Just be aware that the delimeters are fixed length based on the size of each field.

Cjacobsen
 0 pts.
 

Do you mean as a data file, or are you simply trying to store it on IFS?
The newest version of excel (2003) can save as a comma separated values file (CSV) properly – finally!
The file created by excel can be read with cpyfrmimpf without any problems.
If you’re simply trying to upload data to the system, use the upload toolbar button. It can create a file on the system that matches the spreadsheet fields and upload into it automatically.

DDekreon
 0 pts.