How can I import data to mainframe from Excel in REXX
I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset
Software/Hardware used:
Software/Hardware used:
ASKED:
August 11, 2009 11:43 AM
UPDATED:
August 13, 2009 3:06 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.