> In my application I use the following code to create an Excel spreadsheet
> and populate it with the contents of an array that was created with a SQL
> Select into statement. Sometimes the array is large, over a 1000 records,
> and this process can be lengthy (5-10 minutes). Any advice on how to speed
> this up?
Is it feasible, instead of using an array, to use a cursor or table?
I just tried COPY TO .. TYPE XLS with 1400+ records from a cursor, and
it took a second or so. I'm using a P120 with 32Mb RAM & Windows '95.
/Paul