We have a legacy application which is in VB. we are migrating it in vb.net (2005).

While coding we found ourself in a fix, the scenario is --

In vb for fetching data we are using Recordset,

While iterating this using while loop we found that iteration is taking 21 sec to fetch about 450 records and looping through them and assigning respective values to excel sheet cells.

For the same thing...