Hi Dave.
>Thank you, Doug. That works and is simple enough for even me to understand. My only problem now is that my database has almost 900,000 records in it, and it looks like this is going to take a very long time to run. Are you willing to share your more efficient way of doing this?
As Tore pointed out, make sure you have an index on Field2. Then you could use something like this (just winging it; you may have to tweak it):
update MyTable set Field1 = ExcelCursor.Field1 from MyTable join ExcelCursor where MyTable.Field2 = ExcelCursor.Field2
Doug