How can I import data to mainframe from Excel in REXX

Tags:
Microsoft Excel
REXX
REXX Mainframe
I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset

Answer Wiki

Thanks. We'll let you know when a new response is added.

A lot depends on what format you want for the mainframe file. A simple format that can be created by the Save As… menu choice is to select the CSV format and say “Yes” to the two warning prompts that follow. The result will be a text file in the .csv format. This will have the column labels in the first line, followed by the data in the following lines.

If you want a fixed column format, save it the printer format (.prn). You can view it in Notepad to confirm the result. This format will size the columns according to the longest content in each column. Again, the first line will be the column titles, a direct copy of the first line, or just the data if there are no column titles.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    The data will have to be removed from the spread sheet before using FTP (or something else) to move the file. I am unaware of EXCEL having any sort of EXPORT function. I know there is an IMPORT function. Generally, people take data from the mainframe and populate a spread sheet. Interesting that you want to do it the other way around. Remember VisiCalc? A mainframe based spreadsheet.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following