Results 1 to 5 of 5

Thread: Transfering Data from Excel to IBM application

  1. #1

    Transfering Data from Excel to IBM application



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I need to transfer the data from Excel like Employee Number to the employee no field in an IBM application.

    How do i access the IBM application & the position of the employee field in the IBM application where the employee no has to be pasted through VBA.

    I have not written the code ,hope you could give me an idea.


    Thanking you in advance.

    MVEL

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Well, that depends on a few things:

    • Which application it is
    • Does it support reading and writing to the database vs ADO or ODBC?
    • Does your machine have the driver to do this?
    • What the table names and fields names are in the database?



    Let's start with what application it is, as this may help determine the rest.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Hi Ken

    Thanks for your reply.

    Its a mainframe application called I90 from which we can access data pertaining to employees.

    We need to just input the employee number on the I90 screen against the employee number & then press the enter key to retrieve data pertaining to that employee.

    Thanks

    MVEL

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    The question is if I90 supports ODBC connections. I can't find anything about this software on the internet, so you may want to ask your product vendor/IT department if there is an ODBC driver for it. If there isn't... I'm not going to say it couldn't be done, but it could be very very hard to do.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Thanks Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •