Manpreet Saini
New Member
Hi Team,
i have a large data in SQL which i have to get and paste same data to existing excel . I am storing the data in collection and then using the write collection to insert the data into excel. But this method is too slow .
So i have tried another method using OLEDB , but it is also inserting row one by one .
Could you please help me to give any fastest way to do so ...
Thanks in advance!!!
i have a large data in SQL which i have to get and paste same data to existing excel . I am storing the data in collection and then using the write collection to insert the data into excel. But this method is too slow .
So i have tried another method using OLEDB , but it is also inserting row one by one .
Could you please help me to give any fastest way to do so ...
Thanks in advance!!!