|
View previous topic :: View next topic
|
| Author |
Message |
Ashish Mohan Sharma
New User
Joined: 30 Sep 2008
Posts: 22
Location: Pune
|
|
|
|
Hi All
I have a data in an excel sheet, now i want to have that data (only 1 column) into a flat file. Please assist me how to do it. |
|
| Back to top |
|
 |
Ashish Mohan Sharma
New User
Joined: 30 Sep 2008
Posts: 22
Location: Pune
|
|
|
|
| By flat file I mean mainframe PS file. |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1356
Location: Israel
|
|
|
|
Save your excel file as a text file or CSV. This will produce a flat ASCII file that can be transferred to the mainframe.
File -> Save As... -> Text (Tab delimited) (*.txt) or CSV (Comma delimited) (*.csv) |
|
| Back to top |
|
|
Ashish Mohan Sharma
New User
Joined: 30 Sep 2008
Posts: 22
Location: Pune
|
|
|
|
| How to transfer it to the mainframe? |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| FTP would be the most likely method, if you have the authority to use it. |
|
| Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007
Posts: 171
Location: India
|
|
|
|
Hi,
Once you save the Excel file By giving option 6(command) in the ISPF menu if you select the ACTIONS ---> Send file you can do it. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello Anand,
Please review this topic as to the requirement. Ashish wants to pull data from a spreadsheet on the pc and upload this data to the mainframe. |
|
| Back to top |
|
|
Itanium
Active User
Joined: 22 Jan 2006
Posts: 114
Location: India
|
|
|
|
if that excel is having only one column... then why does it need to be in Excel ? convert that to a txt file or csv file and upload to mainframe.
For upload options, check your emulator.
If you dont have any, check how to use FTP in your shop. |
|
| Back to top |
|
|
|
|
