suhag_akash
New Member
I am trying to update 450 rows in an excel file (4 to 5 hundred thousand records).
all rows in the excel file are unique.
it is taking a lot of time to update the excel file. even after updating the row it is checking all the records to update thinking there are other rows as well to update.
like we use top, limit query while fetching the data (select top 5 table_name where group_id='abc')
is there any way using such command in update query.
so that after updating a row it doesn't look ahead to update more rows.
all rows in the excel file are unique.
it is taking a lot of time to update the excel file. even after updating the row it is checking all the records to update thinking there are other rows as well to update.
like we use top, limit query while fetching the data (select top 5 table_name where group_id='abc')
is there any way using such command in update query.
so that after updating a row it doesn't look ahead to update more rows.