Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 4
Default 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   Report Post  
Nick Hodge
 
Posts: n/a
Default

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   Report Post  
Junior Member
 
Posts: 4
Default

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:
Originally Posted by Nick Hodge
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
  #4   Report Post  
Nick Hodge
 
Posts: n/a
Default

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



  #5   Report Post  
DB2
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
2003 Excel isn't reading the book.xlt file on startup. rlweaver007 Excel Discussion (Misc queries) 1 March 15th 05 10:26 AM
Need to save file for mainframe Rick Excel Discussion (Misc queries) 2 February 15th 05 11:49 PM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 05:19 AM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 04:39 PM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"