ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

AS400 to Excel sheet--file not downloaded completely

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • AS400 to Excel sheet--file not downloaded completely

    Hi,

    I have around 2 lac of records in my physical file which i want to upload to an excel sheet. My problem is that an excel sheet can have max 65536 records. Is there any way to handle this problem and write the remaining records in different sheet on the same excel file?

    TIA
    Regards,
    Ruma

  • #2
    Re: AS400 to Excel sheet--file not downloaded completely

    Whatz lac ?

    Anyway I would just export as csv file then use access to store the data.
    Can you use Microsoft access?

    Jamie
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

    Comment


    • #3
      Re: AS400 to Excel sheet--file not downloaded completely

      hi Jamie,

      lac meaning lakh

      is it not possible to upload in a excel sheet?? we dont use access.

      TIA
      Regards,
      Ruma

      Comment


      • #4
        Re: AS400 to Excel sheet--file not downloaded completely

        Well, you could do something like

        CPYF FROMFILE(FILENAME) TOFILE(WORKFILE1) CRTFILE(*YES) FROMRCD(1) TORCD(65000)

        Transfer that to one Excel form, then

        CPYF FROMFILE(FILENAME) TOFILE(WORKFILE2) CRTFILE(*YES) FROMRCD(65001) TORCD(130000)

        If you are really stuck on using Excel.

        Comment


        • #5
          Re: AS400 to Excel sheet--file not downloaded completely

          check this out im learning

          A lakh (also spelled lac or laksha) is a unit in a traditional number system, still widely used in India and Bangladesh, equal to a hundred thousand. A hundred lakhs make a crore.

          This system of measurement also introduces separators into numbers in a place that is different from what is common outside India. For example, 3 million (30 lakh) would be written as 30,00,000.
          All my answers were extracted from the "Big Dummy's Guide to the As400"
          and I take no responsibility for any of them.

          www.code400.com

          Comment


          • #6
            Re: AS400 to Excel sheet--file not downloaded completely

            hey jamie... is this also comin from the dummy's guide?? (--All my answers were extracted from the "Big Dummy's Guide to the As400" and I take no responsibility for any of them. )
            just kiddin...

            thanks arrow... i will check and let know...
            Regards,
            Ruma

            Comment


            • #7
              Re: AS400 to Excel sheet--file not downloaded completely

              I also didn't know what a lac was. If the file is 3 million records, my suggestion prob isn't practical. You are going to have LOTS of Excel files!

              Comment


              • #8
                Re: AS400 to Excel sheet--file not downloaded completely

                Are you trying to do this inside a program? Or will a command line solution be enough?

                Michael
                "Time passes, but sometimes it beats the <crap> out of you as it goes."

                Comment


                • #9
                  Re: AS400 to Excel sheet--file not downloaded completely

                  its in a program
                  Regards,
                  Ruma

                  Comment


                  • #10
                    Re: AS400 to Excel sheet--file not downloaded completely

                    Generating Excel Documents in RPG Using Freeware

                    iSeries Network Club Tech Programming Tips Newsletter

                    Date: May 15, 2003

                    Geert Van Landeghem has written an excellent tutorial on how to convert iSeries physical files to Excel (.XLS) format. The methods he describes run natively on the iSeries using a mix of Java and RPG. The Java portion relies on classes in the open source POI HSSF library from the Apache Software Foundation. He provides sample Java and RPG source code in his tutorial, which you can read at http://www.jasservices.com/articles/...1_genexcel.htm.

                    The above tutorial shows how to convert to XLS files; converting to comma- separated variable (CSV) files -- which can be read by Excel and other programs -- is easier. Here's a list of free source utilities and source code to convert iSeries physical files to CSV files:

                    a. IBM's CPYTOIMPF command

                    b. Herman Van der Staey's CPYTOXLS Utility, a wrapper for CPYTOIMPF:


                    c. UZAEMON's Convert to CSV File (CRTCSVF) Utility:


                    d. Peter Clifford's Convert To Stream File (CVTTOSTMF) Utility:
                    This utility is available to iSeries Network professional members at http://www.iseriesnetwork.com/featur...rticleID=11126.
                    "Time passes, but sometimes it beats the <crap> out of you as it goes."

                    Comment


                    • #11
                      Re: AS400 to Excel sheet--file not downloaded completely

                      Hi ..

                      I am not able to see the site

                      http://www.jasservices.com/articles...01_genexcel.htm.

                      Can u try & let me know ...
                      Thanks,
                      Giri

                      Comment


                      • #12
                        Re: AS400 to Excel sheet--file not downloaded completely

                        Originally posted by giri View Post
                        Hi ..

                        I am not able to see the site

                        http://www.jasservices.com/articles...01_genexcel.htm.

                        Can u try & let me know ...
                        hi you are from india.

                        Comment


                        • #13
                          Re: AS400 to Excel sheet--file not downloaded completely

                          Originally posted by sabarishg_2004 View Post
                          hi you are from india.
                          Not unless someone moved Utah lately ...
                          Greg Craill: "Life's hard - Get a helmet !!"

                          Comment

                          Working...
                          X