RE: CA TRANSFER OF CSV,BAI OR XLS FILES (& KEYVIEW) -Reply

[Ken Slaugh <ken.slaugh@xxxxxxxxxx>]

Let Excel create the AS/400 file for you via the shared folders, then
use the CPYFRMPCD command to copy the data into any native physical file
you want. The macro capabilities of Excel are all you need to write to a
mapped network drive on the AS/400. If you want even more macro to/from
AS/400 support, check out our ActiveX AS/400 objects at
http://www.cm-inc.com/AS400ole/

Ken Slaugh
Senior Programmer/System Analyst
AS/400 Professional Network Administrator/MSE
Specialist - Client Access/400
Chouinard & Myhre, Inc.

> >>> Wawrzaszek <wawrzaszek@austeel.com> 03/05/99 10:32am >>>
> HELP!!!!!
> Our bank gave us a new software program called KEYVIEW.  We pick
> up our file
> from them with our check reconcilliation.  The software gives us the
> ability
> to export the data out to either .csv or .bai format.  I have typed a
> file
> with .xls extension to create an excel file also and it allows this.  
> 
> Now for the problem, when I transfer any of these files up to the
> AS400
> the
> fields are not in the same positon.  I transfer it up to a 300 char
> line
> file.  Because the fields are not fixed length on the pc file they are
> just
> separated by a comma on the 400 file.  I really do not want to get
> into
> having to read the 400 file char by char to determine the beginning
> and
> ending positon of each field.  If I put the file into excel first, it
> looks
> great on excel, each field is separate.  If I save it as .xls and do a
> transfer it transfer 1 record and it is encrypted!  The file really
> has
> about 900 records.  Is there something I can do, or does anyone else
> use
> keyview and how did they handle this?
> 
> 
> Thank you in advance, Angie  
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---