Hi there,

Could anybody help?

I am using ADO recordset and Range.CopyFromRecordset method in Exce
VBA application to populate large amount of data into the workseet(s)
I am also using ODBC text driver to open Recordset, Client cursor
original data is in SCV file.

When in debug mode (using Debug.Assert False to break) it performs fas
(I would just hit the Run button). As soon as I remove break point an
let application run alone, it performs terriblly slooow.
For example, 25000 records/lines (3451 KB csv file) are populated in 1
seconds in debug mode vs. 2:16 min in runtime mode ????!!!!

Any advice is welcome!
Thank you.

valentina
:confused

--
Message posted from http://www.ExcelForum.com