Page 1 of 1
How to upload excel sheet to a PS
Posted:
Sun Oct 25, 2009 6:48 pm
by prachi0984
Hi,
Is there any way to upload excel sheet to a PS.
Thanks,
Prachi
Re: How to upload excel sheet to a PS
Posted:
Sun Oct 25, 2009 9:05 pm
by swd
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.
Re: How to upload excel sheet to a PS
Posted:
Mon Oct 26, 2009 4:09 am
by dick scherrer
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.