Transfering Data from Excel to IBM application

MVEL

New member
Joined
Aug 24, 2012
Messages
3
Reaction score
0
Points
0
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
 
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.
 
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
 
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.
 
Back
Top