DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: 16,384 maximum records in excel "copy to"

  1. #1
    Joe Frawley Guest

    16,384 maximum records in excel "copy to"


    Is there a simple way to copy a table to an excel file ("copy to filename
    xls") without hitting the wall of 16,384 maximum records copied? I am
    using vfp 6.0 w/sp 3. Tried it on vfp 7.0 and it also has a maximum of
    16,384 records.

    Thanks,

    Joe Frawley

  2. #2
    Rick Bean Guest

    Re: 16,384 maximum records in excel "copy to"

    Joe,
    Quoting the VFP help file "XL5 ... Creates a Microsoft Excel version 5.0
    worksheet file. ...". Excel version 5.0 had a limit of 16,384 rows. I
    believe version 7.0 (Excel 95) was the first to allow 64k rows, and no
    version of VFP (yet) supports this file type.

    You can COPY TO ... TYPE FOX2X or TYPE DELIMITED - all 32-bit versions of
    Excel can import these. You could also use Automation to directly load a
    spreadsheet if you know each workstation has Excel installed.

    Rick

    "Joe Frawley" <Joe.Frawley@Sercelus.com> wrote in message
    news:3bcc3149$1@news.devx.com...
    >
    > Is there a simple way to copy a table to an excel file ("copy to filename
    > xls") without hitting the wall of 16,384 maximum records copied? I am
    > using vfp 6.0 w/sp 3. Tried it on vfp 7.0 and it also has a maximum of
    > 16,384 records.
    >
    > Thanks,
    >
    > Joe Frawley




  3. #3
    Cindy Winegarden Guest

    Re: 16,384 maximum records in excel "copy to"

    Another solution, depending on the number of columns, is
    _VFP.DataToClip(,,3)
    oExcel.Paste()

    You're limited by the size of a VFP array, and it may not be particularly
    fast. Depends on how you're going to use it - I do a lot of these in the
    command window where extra seconds don't matter that much.

    --

    Cindy Winegarden MCSD, Microsoft MVP
    cindy.winegarden@mvps.org
    http://cindywinegarden.adsl.duke.edu


    "Rick Bean" <rgbean@NOSPAMmelange-inc.com> wrote in message
    news:3bcc6e91$1@news.devx.com...
    > Joe,
    > Quoting the VFP help file "XL5 ... Creates a Microsoft Excel version 5.0
    > worksheet file. ...". Excel version 5.0 had a limit of 16,384 rows. I
    > believe version 7.0 (Excel 95) was the first to allow 64k rows, and no
    > version of VFP (yet) supports this file type.
    >
    > You can COPY TO ... TYPE FOX2X or TYPE DELIMITED - all 32-bit versions of
    > Excel can import these. You could also use Automation to directly load a
    > spreadsheet if you know each workstation has Excel installed.
    >
    > Rick
    >
    > "Joe Frawley" <Joe.Frawley@Sercelus.com> wrote in message
    > news:3bcc3149$1@news.devx.com...
    > >
    > > Is there a simple way to copy a table to an excel file ("copy to

    filename
    > > xls") without hitting the wall of 16,384 maximum records copied? I am
    > > using vfp 6.0 w/sp 3. Tried it on vfp 7.0 and it also has a maximum of
    > > 16,384 records.
    > >
    > > Thanks,
    > >
    > > Joe Frawley

    >
    >




  4. #4
    Nancy Folsom Guest

    Re: 16,384 maximum records in excel "copy to"

    "Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
    news:3bcd1d79@news.devx.com...
    > Another solution, depending on the number of columns, is
    > _VFP.DataToClip(,,3)
    > oExcel.Paste()
    >
    > You're limited by the size of a VFP array, and it may not be particularly
    > fast. Depends on how you're going to use it - I do a lot of these in the
    > command window where extra seconds don't matter that much.


    It also, unfortunately, requires the user have Excel installed.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center