mainframe file to excel spreadsheet

[Guest]

When I use batch FTP to send a file from the mainframe ( flat file ) to a
server as an .xls file, I get three columns of data in the first cell ( A1 ).
I would like to know if there is a way to get each of the three pieces of
data per line into three separate cells ? The data looks like this:

OPER.DEVE 014 4/24/2007
OPER.PRDD 043 4/24/2007
OPER.PRDJ 052 4/24/2007

Thanks for any suggestions.

Dave Cox
United Stationers

 

[Dave Peterson]

After you have the data in column A, select that column
Then Data|Text to columns
Delimited (by space)
and choose the correct format for each field/column

In fact, if the mainframe dataset is transferred as a text file onto your pc AND
you saved that file as a Text file (*.txt), then you should see this import
wizard when you open the file (via File|Open within excel).

 

[Guest]

Thanks Dave for your response. I will try out your suggestion on Wednesday
and let you know how it goes. The file was FTP'ed to an .xls file directly,
so no interaction with .txt file format. My idea was to circumvent that
manual operation and go directly into a spreadsheet with the data. Each
field in the data, even though in column A as one whole piece, is separated
by two spaces within column A. I was hoping to get each of three fields in
its own cell through the FTP, but that is not possible.

Dave

 

[Dave Peterson]

Just curious if the person who wrote the mainframe program that created the file
to be FTP'd created a text file and named it .xls.

You may want to use NotePad to look at that .xls file that was FTP'd (before you
bring it into excel). Remember to close NotePad without saving.

 

[Guest]

Dave,
I wrote the program, which was a little Easytrieve program, to create the
file from two different lpars on a shared pack and then used the FTP step
going directly from the mainframe file into an .xls spreadsheet. Not much
mystery about that, pretty straightforward. The only thing is the result. I
will try out your suggestion as soon as I can. I have several different
things on my plate at work right now. Thanks again.

Dave Cox

 

[Dave Peterson]

I hope you're actually using Easytrieve (not Easytrieve Plus)! (1980 still
lives!)

I don't know what lpars means, but easytrieve is gonna just send a text file,
isn't it--not really an excel workbook.

Dave,
I wrote the program, which was a little Easytrieve program, to create the
file from two different lpars on a shared pack and then used the FTP step
going directly from the mainframe file into an .xls spreadsheet. Not much
mystery about that, pretty straightforward. The only thing is the result. I
will try out your suggestion as soon as I can. I have several different
things on my plate at work right now. Thanks again.

Dave Cox

 

[Payal]

Hi .. Could you please provide code to transfer to mainframe dataset data into Excel sheet.

 

[Payal]

i want to automate one process wherin I want to transfer the result into an excel sheet and circulate to team. Please help me..