Query Related to uploading/FTPing XLS file to AS/400

40 pts.
I have a requirement which I need to receive a file from another server to AS/400 server by FTP. The problem is that the file is in xls format. As per my knowledge the XLS file can not be uploaded to AS/400 and we need to manually convert it to .csv. But in this case manual intervention is not possible. Here my questions are:
  1. Whether we can directly upload the xls file to as400 without manually converting it to csv ot txt?
  2. Can we receive the xls file from other server as csv file at our server through FTP?

Software/Hardware used:

Answer Wiki

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

I haven’t tried it, but there’s an XLS Excel parser out there. See http://www.easy400.net/xlparse/html/page2.htm.


Discuss This Question: 4  Replies

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.
  • ToddN2000
    Are you trying to receive this XLS directly into an AS/400 file using FTP? Have you tried to FTP this file to the IFS and then load it from there? I have always had issues trying to load XLS file formats due to excel formatting issues. It may not be possible to go straight to a 400 file without the FDF file that the excel add-on uses to define the fields in the spreadsheet.
    135,485 pointsBadges:
  • Splat
    I would think you could ftp the .xls into a flat file in the QSYS file system then have a program remove the unneeded elements before loading the data into the desired target.
    12,915 pointsBadges:
  • Genderhayes
    The CSV files (which contain text qualifiers) will be automatically downloaded from a SFTP site and pushed to fixed width files for AS400 integration. The customer currently has someone manually log into SFTP site, download file(s), open in Excel and save as XLS. They have no control of original format or naming so the script must be able to convert files regardless of file name and/or number of files
    10,730 pointsBadges:
  • Splat
    Genderhayes, I'd recommend that the files not be converted from .csv to .xls.  If the format is consistent, the CPYFRMIMPF command can be used to import the data from an IFS folder into an iSeries file.
    12,915 pointsBadges:

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.

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


Share this item with your network: