RE: Transferring Excel info to Client Access screen

["Nathan M. Andelin" <nandel@xxxxxxxxxxxxxxxxxxx>]

Steve,

If data validation in Excel is problematic at best, it begs the question why
use Excel for database maintenance?  Why not provide an RPG program in the
first place?

If there is a good reason for using Excel, how about using an ODBC
connection to store Excel rows in a temporary "work" table on the iSeries,
then providing an RPG program for validating and posting the work table to
the permanent database?

HTH,

Nathan.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve McKay
Sent: Friday, January 07, 2005 10: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