The delete you've coded does ALL the needed deletes in one fell swoop, and having a loop isn't going to help with that DELETE.   You do need a row number...

I'm doubtful this could work.   Excel picks a data type and then you are stuck with it.   This would be much easier to handle with T-SQL after exporting the Excel...

Check here to see what you can learn:

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

At first I thought about the idea of replicating a view as a table as potentially problematic, so I did a web search and found some text on this Microsoft...