Send updates back to SQL server when typed into a data table

[RobExcel]

I know it is possible to use VBA to update SQL Server tables with data entered into Excel cells by the user. I have heard that there might be a built-in way to do this in Excel. Is it possible to insert a table/query into an Excel sheet and then have Excel send updates made by the user back to the SQL Server table? I know this can be done in Access and for reasons not germane to this questions, that's not an option.

As an example, assume I query TABLE1 from SQL and the results are put in a table in cells B2:C3 as follows:

[TABLE="width: 200"]
<tbody>[TR]
[TD]Widgets[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Super Widgets[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

The user then types a new widget count into cell C2:

[TABLE="width: 200"]
<tbody>[TR]
[TD]Widgets[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Super Widgets[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Can Excel automatically update the value in SQL or does VBA need to be written to handle this?

Thanks
Rob