Cindy,

What kind of differences? Anything major?

TIA,
Jonathan

>Tom,
>
>Now I'm wondering what DataToClip() does underneath! There are a few differences between what DataToClip produces and what COPY TO produces.
>
>
>>Cindy, here is what I found out via some testing of my own. I created
>>a 6 column cursor containing 65,000 rows of data (near the Excel 64K limit).
>>
>>I then wanted to see how long it would take for the various copy methods
>>to work. Here are the results:
>>
>>1.) COPY TO ... TYPE XLS - 10.813 seconds but only 16,383 rows copied.
>> I did this to show that VFP does not report an error when reaching
>> the 16,383 limit.
>>
>>
>>2.) Application.DataToClip(,,3) - 54.422 seconds.
>>
>>3.) COPY TO filename DELIMITED WITH TAB then
>> _CLIPTEXT = FILETOSTR(filename) - 37.172 seconds.
>>
>>Options 1 and 2 take about the same time with less than 20K rows.
>>
>>It is interesting that option 3 with two VFP commands is indeed faster than the single DataToClip()...