RE: Transferring Excel info to Client Access screen

In the past when I've received files to the iSeries from a variety of
other sources I'd always move it into a work file, perform any edit
checks, if it passed, I'd move it on to its destination, otherwise I'd
copy the record into a history/error log file and send a message to the
IT department.
 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve McKay
Sent: Friday, January 07, 2005 11:15 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Transferring Excel info to Client Access screen

Does anyone know if we can transfer information from Excel to a Client
Access * green screen*?  We have some users that have some information
in a spreadsheet that needs to be entered into an iSeries database.  I
know that we can do a file transfer directly to a specific file using CA
add-ins but this bypasses certain edits that would be performed by green
screen data entry.

I couldn't see any way using CA macros from an emulation session to
perform this task.

Ideas or suggestions welcome.

Thanks,

Steve 



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.