RE: CA TRANSFER OF CSV../CPYFRMPCD

[wawrzaszek@xxxxxxxxxxx (Wawrzaszek)]

I am not a PC person so I don't know if I did what you said.  I created an
excel spreadsheet of the file and put it on our mapped network drive.  I
tried to send it using CPYFRMPCD put it tells me it cannot find document
key.xls (the name of my spreadsheet).  Was I suppose to do something else?
You talk about using macros, and letting excel create the AS400 file so I'm
assuming I am missing alot since all I did was put the info into a spreadsheet.
 
Please help!  Thanks

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

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