General information
Category:
Coding, syntax & commands
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()...
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