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
>