RE: Transferring Excel info to Client Access screen

Maybe I'm thinking "too simple" here but we do this using the simple
Copy/Paste functions all the time.  For example, I've got a Excel sheet
with info in it with the same "columns" as a data entry screen on the
400 (via CA).  In Excel, highlight the chunk of stuff you want to "copy"
to the data entry screen.  Now go to the data entry screen and put your
cursor in the first field and line.  Hit Paste.  If your copy chunk is
bigger than the allowed lines on your screen, hit Page Down (for another
set of lines in your data entry program) and go up to File/Paste Next
and you get the next set of stuff.  Keep doing this until done.

Now I do recall that you have to have a particular setting in CA to make
this work correctly.  I think it is up under Edit/Preferences/Edit and
have Tab Character processing set to either Advance to next Tab stop set
to 60 or Paste Data to fields (this is with CA V5R2).  I think in
previous CA versions, you only have the choice for Advance To Next Tab
Stop to set.

-----Original Message-----
From: Nathan M. Andelin [mailto:nandel@xxxxxxxxxxxxxxxxxxx] 
Sent: Friday, January 07, 2005 10:39 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Transferring Excel info to Client Access screen


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 



-- 
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.



_________________________________________________
Scanned on 07 Jan 2005 17:40:14