Comparing table with excel spreadsheet

Hi all,

I have two tables in SQL Server 2005 and excel sheet ( Office 2003).

The colums of excel sheet are: name ,ssn, flagbit ( Note: Excel sheet contains data already)

Columns of table_one and table_two are: name ,ssn

I want to compare the ssn field from table_one and ssn in excelsheet_one, if it matches , then flagbit in excelsheet_one should say"T1".

If i compare ssn field from table_two and ssn in excelsheet_one, if it matches, the flagbit in excelsheet_one should say "T2".

Ex:

Table_one (input) - excelsheet_one ( Output)

ssn name - ssn name flagbit

11 NYC - 11 NYC T1

Both the tables refers same excelsheet_one and have to update the same flag bit column in excelsheet.

Basically, i want to compare table and excel sheet, then if it matches, then update excel sheet.

Does anybody how to do this.

Any help will be greatly appreciated.

Thanks

Export your table to excel and then do the work there.

Compare/Sync functions and plug-ins

I have two questions.

Q1 : (Note: I had posted a similar query in Data Dude (Visual Studio Team System for DB Professionals) forums and got an answer (nothing conclusive though). Given the context, thought this will also be a good forum to run the post). Onto my question :

Data Dude has Compare and Synchronization functionality for SQL Server. Are there any plans to integrate the same as part of SQL Server Management Studio ? We DBAs work only with SSMS and not Visual Studio. Are there any near term/long terms plans in this direction ?

My original post in Data Dude forums can be found here :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1016505&SiteID=1

Q2 : I came across this thread which discusses about developing Plug-ins for Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192769&SiteID=1
Any approximate time line by which we can expect this ?

Appreciate your response.

Krish

I believe it will be good if you have upadted the same on http://connect.microsoft.com/ with the requirement, as they are monitored on daily basis and your request might be considered in future releases of Service pack.

sqlsql