Insert Bulk Data in excel

[Manpreet Saini]

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!!!

 

[Manpreet Saini]

Hello everyone,

please help me out for this, as write collection is taking more time to write bulk data in excel

 

[RobertJ]

You might find writing the collection to a CSV file faster. You can then still open it in Excel if needed.

 

[Aravindbabu_05]

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!!!

Hi Saini,
Here i can share you 2 ways that might optimize your process.
1. You can directly extract the data from SQL in to Excel.
2. You can use copy and paste by using global send keys if you need to write the whole data at once.

 

[Manpreet Saini]

You might find writing the collection to a CSV file faster. You can then still open it in Excel if needed.

Thanks @RobertJ for the response.

it would be very helpful if you can elaborate or give an example of this.

 

[Manpreet Saini]

Hi Saini,
Here i can share you 2 ways that might optimize your process.
1. You can directly extract the data from SQL in to Excel.
2. You can use copy and paste by using global send keys if you need to write the whole data at once.

Thanks @Aravindbabu_05 .

i have extracted the data into csv file then used copy and paste action to perform the process.