Finally, with either approach be sure to clean up any Excel spreadsheets or temporary tables once you are finished with them.
Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an Edgewood Solutions SQL Server Consultant, co-founder and Baltimore SSUG co-leader.
We always upload the data to a table and then begin the process.
Although this process works are you familiar with any other options to directly perform the INSERT, UPDATE or DELETE operations?
Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!