It is taking so much time to insert around 2000 row data in SQL from excel

Learn
, , , ,
1

First I am reading the Excel and storing the data in Data Table and then using for each loop to insert data in data base for each row.
So for around 2000 rows data it is taking more then 20 minutes.

Please suggest me any solution for making executing fast.

2

@patidarsumeet1 - pls try below…
1- pls chk the excel is not having a line/format gaps… if yes - pls clear the line gaps n format issues…
2- why can’t you try bulk insert statement like - SQL Statement having Insert with Bulk insert syntax