Ask a Question Sign up for Free 118 Experts currently online. Ask Questions for Free!

How to transfer a mainframe file to excel - Excel Links

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

Results 1 to 5 of 5

  1. #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


    --
    sesh
    sesh
  2. #2

    Re: How to transfer a mainframe file to excel

    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.

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


    "sesh" <excelbanter.com> wrote in message
    news:excelbanter.com... 


    Nick
  3. #3

    How to transfer a mainframe file to excel


    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
    sesh
  4. #4

    Re: How to transfer a mainframe file to excel

    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 Data>External 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
    co.uk.ANDTHIS


    "sesh" <excelbanter.com> wrote in message
    news:excelbanter.com... 


    Nick
  5. #5

    Re: How to transfer a mainframe file to excel

    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 <excelbanter.com> wrote in message news:<excelbanter.com>... 
    DB2

Similar Threads

  1. reliable file transfer
    By DC in forum Microsoft Groove
    Replies: 3
    Last Post: 04-12, 06:04 AM
  2. Replies: 2
    Last Post: 11-03, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100