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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.