Automate extraction of data from mainframe report into spreadsheet

D

Dave Cox

Has someone come up with a process where they automate the extraction of
mainframe report data ( it would be FTP'ed down into a text file ) and
getting that data into an Excel spreadsheet ? There are a few wrinkles in
what I would like to happen:
1.) I know how to FTP report file from mainframe down to PC as .txt file.
2.) I don't know how to extract data I want from the report .txt file so
that I can get it into the spreadsheet. I do not want a manual process, so I
would want that automated.
3.) Once the data from a certain day is in the spreadsheet, can I update
the same sheet day after day adding the data from the current day to the next
open cell ? Across the sheet, I would need a date field, PCTG ( percentage )
A, PCTG B, and PCTG C. So, four fields per row per day.
4.) When the month changes, can I create a new sheet and begin the process
over again within this new sheet ?

I appreciate anyone's help with this.

Thanks,
Dave Cox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Create a dynamic master file 1
Linking data in MS Word into Excel 5
Need Help with a VBA subroutine 0
How to extract data from a spreadsheet into a form/create form from spreadsheet data 3
data from multiple files: best way to extract 1
Creating a Search using a combo box and then creating a report. 4

Top