3 Replies Latest reply on Mar 11, 2010 12:42 PM by jtacoma

    Exporting into Excel - large file

    jtacoma

      Title

      Exporting into Excel - large file

      Post

      I have 250,000 records that I need to put into excel to look at and crunch information graphically. only 66,000 records can be brought into excel at a time it appears. it would not be an issue for me to create a 4 page excel file and crunch the info from there - but i do not see any options ot limit what is being exported (ex. export records 1-60,000) do anyone know how i can get all this info in>????

        • 1. Re: Exporting into Excel - large file
          philmodjunk

          Export records exports all the records present in your current found set. Thus, you can limit the number of record exported by controlling which records are present in your current found set.

          • 2. Re: Exporting into Excel - large file
            mrvodka

            In pre 2007 versions of Excel, the row limit was 65,536. So in your case you could have 4 exports of 62,500 records.

            You would have to have 4 found sets and exports.

             

             

            i think you may be able to script the export with a script kind of like the following:

             

            Set Variable [ $end; Get ( FoundCount ) ]

            Set Variable [ $limit; 625000 ]  //whatever limit you want to break it down into

            Set Variable [ $n; Ceiling ( $end / $limit ) ]

            Loop

            Exit Loop If [ $i >= $n ]

              Go to Record [ 1 + $limit * $i ]

              Omit Multiple [ $limit ]

              Show Omitted Only

              Set Variable [ $path; "file:" & Get ( DesktopPath ) & "whatever" & $i & ".xls" ]

              Export Records [ $path ]

              Show All Records

              Set Variable [ $i; $i + 1 ]

            End Loop

             

             

             

            P.S. The script hasnt been tested so it may need some tweaking.

             

             

             

             

             

            • 3. Re: Exporting into Excel - large file
              jtacoma

              sweet and simple - just how i like it... thanks!