I have program which exports a report to excel. I use office aoutomation to fill the rows/cells with data from queries.
The problem is it writes several thousand lines to 10 different worksheets in one .xls file.

And it runs for hours! I means if I start in the aftrnoon it isn't done the next morning!

I need to use a template sheet for the headers

Is there a fast way to append a whole cursor/table to for example worksheet 3 starting at row 6?

like :

oExcel.Worksheet(3).InsertDBF(6,1)

HELP!

Peter