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: 1353 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: 19244 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 |
|
|
|