RE: Data transfer to excel

["Jose Vega" <jvega@xxxxxxxxx>]

Have you used Client Access to transfer from a PC to the AS400? I have
tried in the past and been unsuccessful with client access. I just want
to know if there are certain gotchas I should have been aware of.


-----Original Message-----
From: Jim_Hawkins@tsss.com [mailto:Jim_Hawkins@tsss.com]
Sent: Tuesday, June 05, 2001 8:52 AM
To: rpg400-l@midrange.com
Subject: Data transfer to excel



If I am transferring data into an Excel spreadsheet I have always used
the
Client Access data transfer utility.  It has always worked well for me
and
provides the ability to create an SQL selection criteria on the
download.
The only gotcha I have ran into is to make sure that in the properties
you
have selected that CCISD 65535 conversion is selected.

The beauty of this is that it works from within Excel.

Jim Hawkins
Programmer/Analyst
Triple S Plastics
Vicksburg, MI


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---