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:

Widgets	5
Super Widgets	2

<tbody>
</tbody>

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

Widgets	10
Super Widgets	2

<tbody>
</tbody>

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

Thanks
Rob