• Subject: CA TRANSFER OF CSV,BAI OR XLS FILES (& KEYVIEW)
  • From: wawrzaszek@xxxxxxxxxxx (Wawrzaszek)
  • Date: Fri, 5 Mar 1999 11:32:00 -0500

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

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].