How do I FTP a data in a MS Excel workbook on the user's desktop to a mainframe (dataset)?

How do I FTP a data in a MS Excel workbook on the user's desktop to a mainframe (dataset)?
vijethbalaramAsked:
Who is Participating?
 
rspahitzCommented:
So back to the question...are you asking how to get Excel to transfer data from the sheet to a different location (mainframe)?
If so, there's nothing built in, but I'm doing that exact thing through macros.
Basically, I have the macro create a text file (from various cells) then use a Shell command to run an FTP application (sFTP) to transfer the file to the designated location with the proper user and password.  this can also be done with the built-in windows FTP is the remote machine supports standard FTP.
0
 
rspahitzCommented:
First, export the data in a format such as CSV.
then you can download a tool like WinSCP and use that to transfer the file.
Once it's there, you'll have to put it in a place you want on the mainframe.
0
 
giltjrCommented:
What is the OS on the mainframe?  

Unless the OS has a program that can read xls or xlsx formated file you need to save it as a CSV or text file and then use whatever file transfer method the mainframe supports.  Typically you would contact the people that support the mainframe to find out, but it depends on the OS.

IBM zSeries mainframes can run one of 4 operating system: z/OS, z/VM, z/VSE, and/or Linux.

Linux on a mainframe is just like Linux on any other hardware.

z/OS suppport FTP, FTPS, SFTP, SCP, RCP, and IND$FILE.

I don't deal with z/VM or z/VSE, but I would assume they support FTP, FTPS, SFTP, and IND$FILE.
0
 
giltjrCommented:
The mainframe support staff may also give you some special command to issue if you are ftping to z/OS, z/VM, or z/VSE.  

Since you have two questions that are basically the same, you may want to press the "request attention" button and ask to have one of them closed.
0
 
AlexPaceCommented:
You could also use an FTP client with a COM interface so you can pass commands directly into it from your Excel macro but you'd still need to create the text file containing the data.

Another thing to be aware of with mainframes is that some of them use the EBCDIC character set instead of ASCII so if the data comes across partially scrambled you should try sending it in ASCII mode or use an FTP client with built-in ASCII to EBCDIC translation.  Some mainframe FTP servers do this automagically.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.