How to upload excel sheet to a PS



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

How to upload excel sheet to a PS

Postby prachi0984 » Sun Oct 25, 2009 6:48 pm

Hi,

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

Thanks,
Prachi
prachi0984
 
Posts: 2
Joined: Sun Oct 25, 2009 6:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to upload excel sheet to a PS

Postby swd » Sun Oct 25, 2009 9:05 pm

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.
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: How to upload excel sheet to a PS

Postby dick scherrer » Mon Oct 26, 2009 4:09 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post