How can I import data to mainframe from Excel in REXX
Home > IT Answers > Development > How can I import data to mainframe from Excel...
NatpudanMoorthy
5 pts.
0
Q:
How can I import data to mainframe from Excel in REXX
REXX, Microsoft Excel, REXX Mainframe
I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset
ASKED: Aug 11 2009  11:43 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Dmenke38
185 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Aug 13 2009  3:06 PM GMT by Dmenke38   185 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Meandyou   1840 pts.  |   Aug 12 2009  3:55PM GMT

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.

 
0