Thanks, Jos.

That's quick.


>Bill,
>
>Just for comparison I created an array of 10,000 rows and 4 columns and filled it with numeric data. The paste into Excel takes 0.06 seconds.
>
>If I fill the array with strings of 15 characters in length then the paste operation into Excel takes 0.1 seconds.
>
>With 2500 rows x 4 columns the paste operation takes 0.03 seconds using numeric fields and 0.05 seconds using character fields.
>
>
>>For everyone's information:
>>Filling a 4 column worksheet with 2500 rows from a dbf one cell at a time takes about 3 seconds on a pretty fast machine. That was a problem for me since the app in question might have a lot more volume than that at times and that's why I started looking around.
>>Using the array method with the same data, it's instantaneous.
>>Further, MS advises that the Excel interop engine has a 64K space for range references and since each cell fill uses a new range reference, filling a speadsheet with high volumes of data a cell at a time might destabilize the engine.
>>No such problem with the array method
>>