I am using VBA in Excel to connect to a SQL server and retreve data. That
is working. The problem is that I want to run an Update query to update one
line in the database and it isn't working. Below is an example of the code I
am using.


Dim cmdCommand As New ADODB.Command
Dim recSet As New ADODB.Recordset
Dim cn As New ADODB.Connection
cmdCommand.ActiveConnection = cn
strSQLCommand = "UPDATE Materials.ReportName = test Where
materials.MaterialID = 5"
cmdCommand.CommandText = strSQLCommand
cmdCommand.CommandType = adCmdText
Set recSet = cmdCommand.Execute
please help
--
KC