Re: transfer of s36 files from as400 to excel

[dsmithso@xxxxxxxxxxxxxxxxxxxxxxxxx]

You can transfer files in excel but you must go through a couple of steps. First
open the file (be sure to click all files in excel to find it). Then a pop-up
screen for importing will appear. I always pick the fixed format option. From
there you can click next and set the lines to where yout fields end. It is a
good idea to have the file layout ready first. Let me know if you have problems.
We have two "production sides" on our As/400. We have our old code that is S36
code and our new code in OS/400. We download from both into excel.




conor.farrell@dubport.ccs.ie on 06/14/2000 12:34:27 PM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Debra L Smithson/PF/AlleghenyTechnologies)
Subject:  transfer of s36 files from as400 to excel



We have just completed a s36 to as400 migration. I cannot transfer the s36 files
from the AS400 to a spreadsheet as it reads each record as one field.

Has anybody managed to do this

Regards

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