Information générale
Catégorie:
Codage, syntaxe et commandes
Jonathan,
See for yourself.
Take a (little) table, copy to FileName DELIMITED WITH TAB. Open the resulting file.
For the same file, do the DataToClip() and paste into WordPad.
>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()...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement