strSQL="UPDATE TABLE_NAME SET FIELD_NAME="&NUMERIC_VALUE&", FIELD_NAME='"&STRING_VALUE&"' WHERE CONDITIONS" objConn.execute(strSQL)