You can do what you suggesting without using Excel, here's a SQL Server example where @tbl1 is on server 1 and @tbl2 is on server 2:
DECLARE @tbl1 TABLE ( id INT, [status] NVARCHAR(10) )
DECLARE @tbl2 TABLE ( id INT, [status] NVARCHAR(10) )
-- @tbl1 data is different and needs to be sync'd to @tbl2
INSERT INTO @tbl1 ( id , [status] ) VALUES ( 1, 'd' ), ( 2, 'e' ), ( 3, 'f' )
INSERT INTO @tbl2 ( id , [status] ) VALUES ( 1, 'a' ), ( 2, 'b' ), ( 3, 'c' )
-- show current data
SELECT * FROM @tbl1 AS t
SELECT * FROM @tbl2 AS t
-- run a command like this on @tbl1 to generate UPDATE statements
SELECT 'UPDATE @tbl2 SET [status] = ''' + [status] +
''' WHERE id = ' + CAST(t.id AS NVARCHAR(5))
FROM @tbl1 AS t
-- the above will generate this sql, which you can copy across and run on server 2
UPDATE @tbl2 SET [status] = 'd' WHERE id = 1
UPDATE @tbl2 SET [status] = 'e' WHERE id = 2
UPDATE @tbl2 SET [status] = 'f' WHERE id = 3
-- running the generated SQL on server 2 would then give you matching results
SELECT * FROM @tbl1 AS t
SELECT * FROM @tbl2 AS t
Instead of the standard Results to grid output, you can either display results as text or export to a file, to make copying/running the generated SQL easier, and possibly creating the first step of an automated process.
You'll find Query Result output options via the highlighted shortcuts below of via Tools > Options in the menu:
Summary
The actual SQL you will want to run on your source server is something like this:
-- run a command like this on @tbl1 to generate UPDATE statements
SELECT 'UPDATE @tbl2 SET [status] = ''' + [status] +
''' WHERE id = ' + CAST(t.id AS NVARCHAR(5))
FROM @tbl1 AS t
Then you would take the results away to run on the target server.
