I am using ADO to generate few reports in excel using excel as data
source.As the size of data has increased the reports have become very
slow.How can I make these reports faster?

Thanks in advance.

Assuming the report is 'scanning' the rows of data to produce the report in a
sorted order, try sorting the Excel file in advance (and thereafter) to
reduce the number of scans the report writer performs. Works like an index in
a flat-file database.

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"ST" wrote:

I am using ADO to generate few reports in excel using excel as data
source.As the size of data has increased the reports have become very
slow.How can I make these reports faster?

Thanks in advance.