writeback to SQL 2005

[CJ]

hello! I use excel 2007
iI open a connection agianst SQL server 2005 and choose a table. In my
workbook i can now see this data from this table. if i change a value in some
cell i wish to writeback to table in SQL server. Is this possible?

 

[Ross Culver]

It's possible through the use of VBA and ADO, but not simply using the data
connection you've already established.

Ross

 

[CJ]

Why does not microsoft have such in excel?

Several 3 part has it like :

http://www.excel-db.net/sql_server.htm
and
http://pcwin.com/Business___Finance/Excel_MS_SQL_Server_Import__Export___Convert_Software/index.htm