I am trying to FTP an excel file to mainframe dataset using batch process through sysin.
Ex of sysin:
get file.xlsx 'mainframe.file.name' (replace
Using the above sysin if i FTP a text file the data is transferred correctly but if i ftp an excel file i am getting junk values. Should i need to convert the xls file to any other format. Can that conversion be done in mainframe itself. Or should i need to include any commands in the above mentioned sysin for transferring the excel file.
I've seen at least one program that claims to be able to handle Excel data on the mainframe. If I get a chance, I'll find the company again and post it here. However, be aware that such software will cost tens of thousands (or hundreds of thousands) of US dollars for your site (mainframe software is not cheap), so you will have to convince your management that spending the money provides enough benefits.