General information
Category:
Coding, syntax & commands
Kevin, the native COPY TO ... XL5 command is indeed limited to 16,383 rows of data. You can use things like _ClipText = FileToStr() then Paste and/or _VFP.DataToClip() to bring you up to the Excel 2000/2002 limit of 65,536 rows.
What it sounds like you need is to read in external data and create an Excel PivotTable report. I have used this approach to read in over 750,000 rows of data (over 10x the normal worksheet limit).
A pivottable creates a terrific interface to view the data in a multitude of ways. The pivottable will summarize the data for the user while allowing drillthru capabilities so that you can get down to the actual details if need be. The end result is a very powerful combination and one that end users are not afraid of and that needs no outlay of funds for the product or training (most people already have Excel and know how to use it).
>I have the following code:
>
>
>USE MyTable
>COPY TO MyFile.Xls TYPE XLS
>
>The table has 220,000 records in it. I only get around 16,000 lines
>in the Excel file.
>
>What gives?
>
>TIA
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only