How to transfer a mainframe file to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sesh - 21 Apr 2005 00:54 GMT

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

Signature

sesh

Reply to this Message

Nick Hodge - 22 Apr 2005 07:53 GMT

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 (Data>Get External Data>New 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.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Hi,
> I need to transfer one mainframe file to PC in excel format.
[quoted text clipped - 7 lines]
> Thanks,
> Sesh

Reply to this Message