IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to transfer file from PC to MF without data truncation


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
hemanthj642

New User


Joined: 14 Sep 2005
Posts: 21

PostPosted: Tue May 26, 2009 2:52 pm
Reply with quote

Hi, Could you please help me in transferring a excel file from PC to Mainframe. I use FTP in here and when I transfer data I get junk values and not in a proper order
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed May 27, 2009 1:42 am
Reply with quote

Hello and welcome to the forum,

An Excel spreadsheet typically cannot be uploaded to the mainframe as an excel file.

The spreadsheet needs to be saved to a delimited text file and then uploaded to the mainframe. Suggest you pre-allocate the file on the mainframe with a large enough lrecl.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed May 27, 2009 1:10 pm
Reply with quote

Usually I do the same what Dick has said -- "Save As" and select type .CSV and then upload to the Mainframe as TEXT.

You can search the Forum with key-word "excel" to find the other thread on similar topic, one such link is this: www.ibmmainframes.com/viewtopic.php?t=36170&highlight=excel among many.

Hope this helps.
Back to top
View user's profile Send private message
sudalaimani

New User


Joined: 08 Apr 2009
Posts: 2
Location: chennai, india

PostPosted: Wed May 27, 2009 4:37 pm
Reply with quote

Hi ,
Convert your Original excel file into Comma Delimited file by
just saving ur excel ie.. Save as - file type (comma delimited).
Now it is possible to transfer ur file into the data set with the original
contents of ur excel file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top