• Subject: RE: Excel file
  • From: "Jaladi Ravi Kiran , Gurgaon" <jaladirk@xxxxxxxxxxxxxxx>
  • Date: Mon, 29 Nov 1999 09:30:01 +0530

Thank you very much for this information Mr.phil.

Regards
Ravi 

        -----Original Message-----
        From:   philbrewer@johnson-tiles.com
[SMTP:philbrewer@johnson-tiles.com]
        Sent:   Friday, November 26, 1999 7:34 PM
        To:     MIDRANGE-L@midrange.com
        Subject:        Re: Excel file






         You could try using CPYFRMPCD ......

         1) Save your spreadsheet as anyname.txt

         2) In Windows Explorer do Tools-Map Network Drive
             For the path try \\S????????\QDLS      where S???????? is the
id of
         you AS/400

         3) Using Windows explorer copy anyname.txt to a folder in QDLS, we
use a
         folder called transfer

         4) On the AS/400 do CPYFRMPCD FROMFLR(TRANSFER) TOFILE(QGPL/ANYPF)
         FROMDOC(ANYNAME.TXT)
             Where ANYPF is a Physical File you have previously created.



         >I have some records in a Microsoft Excel file, and I want to put
        >this records in to the AS/400 in a Physical file is there any
method to
        transfer this Excel file into AS/400.

        >I tried the Option available in the CA/400 5250 emulation screen
,but it
        bombs.

        >Can anyone give me some suggestion.


        >Thanks
        >Ravi


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


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 on our policy page. If you have questions about this, please contact [javascript protected email address].