IBM Mainframe Forum

Hi,

Is there any way to upload excel sheet to a PS.

Thanks,
Prachi

Export the excel spreadsheet to CSV format and FTP it the the mainframe as a PS file?

Voila!

Your request was a bit vague. Perhaps a bit more detail wouldn't go amiss if this solution does not meet your requirements or expectations.

Hello and welcome to the forum,

You may want to consider a delimiter other than comma as comma is often found in the data (personally i use the pipe or the tilde).

On the mainframe suggest you pre-allocate the target PS file with enough space to hold the upload.

Your desktop tcp/ip software will most likely have an ftp client (rather than being configured as an ftp server). It can be Win-based or run from the command prompt.

Good luck and someone will be here if there are questions/problems.