Screen capture of text

[Rob Bunocore]

I have built an access database to work in conjunction with a
companies mainframe. The system tracks things that the mainframe
system does not.

What I want to do is figure out how to program something to capture
text off the screen and populate certain fields in my database. This
way the user doesn't need to retype the same information that is on
the screen already.

Has anyone done anything like this?

Robby

 

[Rob Parker]

Hi Robby,

I wouldn't fancy your chances of doing a direct screen capture. However, if
the data being displayed from the mainframe is in a file, or can be dumped
to a file, you can use the TransferText method to import data from that
file. The input (text) file can have either fixed width fields or delimited
fields, and you can set up an input specification to read files of a given
format with no user intervention at all. See the Help file for details.

HTH,

Rob

 

[Guest]

I do not know the format it is being display on the screen (text or graphics)
but text that can be copied and pasted into Word can be pasted into Excel and
either imported or as a linked file.