Create Update Query Using SQL in VBA excel

Sub Update_Table()

Dim strsql As String

 

strsql = "Update [Table_name] set [FieldName]=""FT"" where [FieldName]=""Full-Time"""

 

CurrentDb.Execute strsql

 

End Sub

---

Cricket on your mind? Visit the ultimate cricket website. Enter now!