How to insert data fastly in sql

Hi everyone,

I have excel file in which 5 lakh data is present.
I am insert that data in sql but it will take so much time.
So my query is to reduce the insertion time.

And this data is increase month by month.

If it is possible then please give some suggestion

Thanks

Try to perform the insert in several data batches.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.