Updating SQL Server via Excel
 

I see a lot of posts on this subject; none of which seem to address my
issue.

I am running MS Office Excel 2003 and want to update a table located in
a database in SQL Server 2000.

Using VBA for Excel, what options do I have to connect to the database
and then execute an "UPDATE" or "INSERT" SQL statement?

Can someone provide some code snippets or web page references on the
syntax?

Thanks!