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

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

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

sesh

Sorry I was so long getting back. You will need to research if you have
ODBC drivers for the database. If you do it will simply be a case through
Excel of taking DataExternal Data...New database query. You can then
navigate to the external datasource/table, etc and once established you can
simply refresh this query each day by taking the 'refresh' option.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"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-


--
sesh

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-