Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to transfer a mainframe file to excel
Hi,
I need to transfer one mainframe file to PC in excel format. This needs to be done automatically like FTP with out manual intervension. We create report every day in mainframe file format and this report need to be transferred into excel on PC. Can any one help out ? Thanks, Sesh |
#2
|
|||
|
|||
Sesh
It depend on what the 'mainframe' is. Can't give a huge amount of help without, but if it is an AS400 for example you can send a file to FTP, HTTP, Etc FROM the AS400. If you cannot do that then you could use an ODBC driver quite simply from Excel (DataGet External DataNew Database Query...). You will need to navigate to the library on the AS400, using the Client Access driver but once you have the data you can simply, via the same menus, refresh the query each day. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "sesh" wrote in message ... Hi, I need to transfer one mainframe file to PC in excel format. This needs to be done automatically like FTP with out manual intervension. We create report every day in mainframe file format and this report need to be transferred into excel on PC. Can any one help out ? Thanks, Sesh -- sesh |
#3
|
|||
|
|||
Hi Nick,
I need to read the data in DB2 table on Mianframe ( Z/OS) and create the report on excel. According to you I may have ODBC connectivity. Can you please explain me more how to do this ? Do I need to write VB program to populate the data on excel sheet. This excel report needs to be created every day automatically as DB2 will be loaded daily. Can you please tell me how to do this ? Thanks for your help. Sesh Quote:
|
#5
|
|||
|
|||
Hi Sesh,
You will need an ODBC/DRDA driver so that your data can talk to DRDA (IBM's DB2 protocol enabling your database to communicate with distributed systems). One good DB2 driver is StarSQL, available from StarQuest (www.starquest.com). Good luck! Bob sesh wrote in message ... Hi Nick, I need to read the data in DB2 table on Mianframe ( Z/OS) and create the report on excel. According to you I may have ODBC connectivity. Can you please explain me more how to do this ? Do I need to write VB program to populate the data on excel sheet. This excel report needs to be created every day automatically as DB2 will be loaded daily. Can you please tell me how to do this ? Thanks for your help. Sesh Nick Hodge Wrote: Sesh It depend on what the 'mainframe' is. Can't give a huge amount of help without, but if it is an AS400 for example you can send a file to FTP, HTTP, Etc FROM the AS400. If you cannot do that then you could use an ODBC driver quite simply from Excel (DataGet External DataNew Database Query...). You will need to navigate to the library on the AS400, using the Client Access driver but once you have the data you can simply, via the same menus, refresh the query each day. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "sesh" wrote in message ...- Hi, I need to transfer one mainframe file to PC in excel format. This needs to be done automatically like FTP with out manual intervension. We create report every day in mainframe file format and this report need to be transferred into excel on PC. Can any one help out ? Thanks, Sesh -- sesh- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
2003 Excel isn't reading the book.xlt file on startup. | Excel Discussion (Misc queries) | |||
Need to save file for mainframe | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Problem opening an XML file in Excel - getting "ns1:macrosPresent" | Excel Discussion (Misc queries) |