How to convert SqlDataReader to a Recordset in VB.NET

[vladk]

Hi,

I would like to use CopyFromRecordset Excel method to export data to Excel by avoiding looping through the records.
I have SqlDataReader populated with data.
Would it be possible to implement?

Many thanks

vladk

 

[TopTeller]

Hi, you seem a guy who avoid long coding. By the way, I would suggest you to use it in a proper way (as per standards) and not avoid looping. Any other technique may slow down your app. Btw, you can write a sub for looping and call that within your main code.

 

[vladk]

Thank you TopTeller,

I do use a loop of cause, thinking some other approach could accelerate processing.