PDA

View Full Version : Excel and Mainframe apps



sindhuja
04-30-2008, 05:16 PM
Hi,

Is it possible to access the datas in mainframe application from excel using macros.

The data to be retrieved depends on the specific fields in excel. It should search for the entry in mainframe application and display the contents coresponding to that in the excel..

-Sindhuja

Ken Puls
04-30-2008, 09:57 PM
It kind of depends what the mainframe application is, and if it has an avenue to do so. If it is SQL compliant, then probably, if you have the correct connection string. If not, it may be something you'd want to ask the provider.

asingh
05-01-2008, 01:28 AM
Hi,

Which mainframe is it....you can scrape data off the front end (black/green screens)...!.??

sindhuja
05-05-2008, 09:54 PM
Hi,

The application i used to extract data is from a black screen..
Any help on this will be highly helpful...

-Sindhuja