writeback to SQL 2005

C

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?
 
R

Ross Culver

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

Ross
 
Top