Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
well, you have to design/implement and run some type of data retrieval from the mainframe and get it to the pc.
then you have to determine how you are going to process that data and get it into a spreadsheet.
depending upon availablilty of pc languages (any of the microsoft JAVA, C#, VB will directly communicate with an exell spreadsheet).
you could also use rexx.
or, if you are clever and create the data on the mainframe in such a manner that when downloaded to the pc, a simple exell macro will process the data and update your spreadsheet.
